Devart Forums

Posted: **Thu 20 Aug 2020 18:58**

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.

Posted: **Fri 21 Aug 2020 15:35**

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

Devart Forums

multiple implicit cursors

multiple implicit cursors

Re: multiple implicit cursors