PL/SQL print out ref cursor returned by a stored procedure to GRID tabs
Add feature to fetch from a ref cursor returned from a stored procedure (OUT variable) and print the resulting rows to GRID tabs.
Example code to return 2 ref cursors.
CREATE OR REPLACE PROCEDURE spgetsysdate(c1 IN OUT sysrefcursor, c2 IN OUT sysrefcursor) AS
BEGIN
OPEN c1 FOR SELECT SYSDATE FROM dual;
OPEN c2 FOR SELECT SYSDATE-1 FROM dual;
END;
DECLARE
c1 SYSREFCURSOR;
c2 SYSREFCURSOR;
BEGIN
spgetsysdate(c1,c2);
--How to PRINT c1 and c2 to grid tabs like the DEBUGGER?
END;

-
AdminDevart (_, Devart) commented
Hi,
Thanks for your post!
Please be infromed that we have passed this feature request to our Product team for a review.
A hight number of votes here would speed up the review and implementation process, so let's hope to get more votes.
Once there is an update regarding implementation and release, you will be informed.
Best,
Devart Support Team