Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /mnt/web018/d2/82/51207682/htdocs/armbruster-it/joomla33/templates/stefans_blog_05/functions.php on line 182
...
);
CREATE TYPE object_table_type AS TABLE OF object_row_type;
CREATE OR REPLACE FUNCTION GETCLOB RETURN object_table_type PIPELINED IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
insert int ...
... on split_string_pipe(pi_string in varchar2, pi_delimiter in varchar2)
return t_tab_strings pipelined is
l_tab t_tab_strings;
begin
l_tab := split_string(pi_string, pi_delimiter);
...
... _tab_dir);
exception
when others then
rollback;
raise_application_error(-20001, 'File not found');
end;
[...]
Pipelined Function
Now you can use th ...
This article describes how to tokenize a string, just with plain "out of the box" Oracle SQL. In the IT we often encounter requirements to split a string in parts. With Oracle PL/SQL we have a ...