it would by nice if plsqldev could create Test Window for pipelined function, i.e. not
[quote]declare
-- Non-scalar parameters require additional processing
result ma.map_xutils3.line_tbl_type;
begin
-- Call the function
result := ma.map_xutils3.clob2lines(p_clob => :p_clob,
p_delim1 => :p_delim1,
p_delim2 => :p_delim2,
p_str => :p_str,
p_blob => :p_blob,
p_csid => :p_csid,
p_utf8 => :p_utf8);
end;[/quote]
but
[quote]select * from table (ma.map_xutils3.clob2lines(p_clob => :p_clob,
p_delim1 => :p_delim1,
p_delim2 => :p_delim2,
p_str => :p_str,
p_blob => :p_blob,
p_csid => :p_csid,
p_utf8 => :p_utf8))[/quote]