Re: Output of Cursor

from SQL*Plus you just need to declare a variable of REFCURSOR

PUB_at_TESTING>CREATE PROCEDURE test_proc(x OUT SYS_REFCURSOR)   2 IS
  3 BEGIN
  4 OPEN x FOR
  5 SELECT * FROM DUAL;
  6 END;
  7 /

Procedure created.

Elapsed: 00:00:00.76
PUB_at_TESTING>VAR C REFCURSOR;
PUB_at_TESTING>EXEC TEST_PROC(:C); PL/SQL procedure successfully completed.

D
-
X Received on Thu Apr 14 2005 - 11:22:13 CDT