I used the following program to learn bind variables and ref cursor
long time ago. This might help. Put this code into a file called
getstaff.sql and then run it. Bottom lines show how to declare a cursor
and pass it to a procedure using SQL.
HTH
Mohammed Shakir
--
rem filename g
,
HOW do I execute procedure getl from sqlplus?
Kind Regards,
Hatzistavrou Yannis
?
-Original
Message-
From: Regis Biassala
[mailto:[EMAIL PROTECTED]
Sent: Wednesday,
June 04, 2003 6:05
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: passing ref cursor on
a
Title: passing ref cursor on a procedure
example
-Original Message-From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June
04, 2003 2:40 PMTo: Multiple recipients of list
ORACLE-LSubject: passing ref cursor on a
procedure
Dear All,
I have a vendor
pro
Igor
Neyman
Sent: Wednesday, June 04, 2003
9:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: passing ref cursor on
a procedure
If in SQL*Plus:
Just declare variable of
REFCURSOR type and pass it to stored procedure:
DECLARE lCursor
REFCURSOR;
Begin
(par1,
par2, …, :lCursor
Title: passing ref cursor on a procedure
If
in SQL*Plus:
Just declare variable of REFCURSOR type
and pass it to stored procedure:
DECLARE lCursor REFCURSOR;
Begin
(par1, par2, …,
:lCursor);
end;
/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-