enhancement request: Test Window for pipelined function

[marek]

it would by nice if plsqldev could create Test Window for pipelined function, i.e. not

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 => _clob,
p_delim1 => _delim1,
p_delim2 => _delim2,
p_str => _str,
p_blob => _blob,
p_csid => _csid,
p_utf8 => _utf8);
end;

but

select * from table (ma.map_xutils3.clob2lines(p_clob => _clob,
p_delim1 => _delim1,
p_delim2 => _delim2,
p_str => _str,
p_blob => _blob,
p_csid => _csid,
p_utf8 => _utf8))

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[fctb]

Any progress on this (3y old) request?

 

[Tichij]

+1

 

[Stew Stryker]

+1

 

[Marcel Hoefs]

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 => _clob,
p_delim1 => _delim1,
p_delim2 => _delim2,
p_str => _str,
p_blob => _blob,
p_csid => _csid,
p_utf8 => _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.