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]

I have added this to the list of enhancement requests.

Any progress on this (3y old) request?

+1

+1

Or you can use the cursor type variable of the test window.

So e.g., open :result_set for 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)):


Where :result_set is of "type" "cursor" in the test window. Then after running the script you van press the ellipsis (..) all the way to the right of the "value" column in the test window to see the results.