Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Output of Cursor

Re: Output of Cursor

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 14 Apr 2005 09:22:13 -0700
Message-ID: <1113495732.978141.70420@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US