josephtauro
Programmer
- May 14, 2001
- 5
Hi All,
I am using Dynamic PL/SQL in my procedure.My question is how do I pass a cursor out of this Procedure.
e.g ProcedureA(curs1 OUT etc).
In Dynamic PL/SQL when we open a cursor we get a cursor Handle instead of a cursor.
i.e
v_CursorID:=DBMS_SQL.OPEN_CURSOR;
I get only an integer value for this cursor handle.But if I want to pass this cursor Instead of the cursor handle(which is an integer)how do I do it.
Please send me your suggestions.
Regards
Joseph
I am using Dynamic PL/SQL in my procedure.My question is how do I pass a cursor out of this Procedure.
e.g ProcedureA(curs1 OUT etc).
In Dynamic PL/SQL when we open a cursor we get a cursor Handle instead of a cursor.
i.e
v_CursorID:=DBMS_SQL.OPEN_CURSOR;
I get only an integer value for this cursor handle.But if I want to pass this cursor Instead of the cursor handle(which is an integer)how do I do it.
Please send me your suggestions.
Regards
Joseph