multiple implicit cursors

[jdorlon]

Hello,

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;
/

Thanks.

[MaximG]

Please see our documentation for a description of Implicit Result Sets: https://www.devart.com/odac/docs/devart ... next().htm