Oracle 12c DBMS_SQL.RETURN_RESULT with pl/sql dev 11

[sparinfo]

With pl/sql dev 11, I execute the Oracle 12c new feature DBMS_SQL.RETURN_RESULT.

Exemple :

declare
l_cur sys_refcursor;
begin
open l_cur for select * from dual;

dbms_sql.return_result(l_cur);
end;

It works without error, but I don't see the results. Where I can see the results in pl/sql dev 11 ?

Thanks.

 

[Marco Kalter]

Implicit cursor results are not yet supported. This is on the list of enhancement requests.

 

[Luis Ferreira]

Hi,

PlSqlDeveloper 13.0.6
Oracle Client - 19

Are implicit cursors already supported?
Thanks

 

[Marco Kalter]

Implicit results are supported in the Test Window. If you execute a Test Script that creates implicit results, a cursor variable will be added for each result set. You can subsequently click on the implicit cursor variable value button to view the results, just like with normal cursor variables.