Dynamic PL/SQL(Please Reply)

[josephtauro]

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

 

[sem]

You do may pass this handler as integer, so to open cursor in one procedure and pass its handler into another for utilizing. You'll get invalid_cursor error if no cursor with this handler is opened.