Is there any way to get both implicit cursor results from a TSmartQuery running this code? I know that I can get the first one, but I am not sure how to get the 2nd.
Code: Select all
DECLARE
cur1 SYS_REFCURSOR;
cur2 SYS_REFCURSOR;
BEGIN
OPEN cur1
FOR SELECT SYSDATE AS now_1
FROM dual;
OPEN cur2
FOR SELECT SYSDATE AS now_2
FROM dual;
dbms_sql.return_result (cur1);
dbms_sql.return_result (cur2);
END;
/