josephtauro
Programmer
- May 14, 2001
- 5
Is it possible in Dynamic PL/SQL to get a cursor from a cursor handle.
For e.g
v_CursorID:=DBMS_SQL.OPEN_CURSOR;
I get a value of say 4 or any other number for the cursor handler v_CursorID.using this value I need to pass a cursor(Active data set) to any other application.In a nut shell my problem is
1)I need to create a procedure which will pass back a cursor to an applocation.
2)In the same procedure I need to fetch through the records and see for missing records and insert the missing records into the missing_records table.
3)Here is the problem.when I fetch through the cursor my cursor pointer is at the last record of the cursor.
so when I pass this cursor to the application I get NO RECORDS found.
4)To solve this problem I tried using DYNAMIC PL/SQL.
5)with dynamic PL/SQL I dont need to close the cursor and open it again.
6)But the problem is using the cursor handle I need to create a cursor and pass the cursor to an application.
Any help on this matter will be great.
Regards
Joseph
For e.g
v_CursorID:=DBMS_SQL.OPEN_CURSOR;
I get a value of say 4 or any other number for the cursor handler v_CursorID.using this value I need to pass a cursor(Active data set) to any other application.In a nut shell my problem is
1)I need to create a procedure which will pass back a cursor to an applocation.
2)In the same procedure I need to fetch through the records and see for missing records and insert the missing records into the missing_records table.
3)Here is the problem.when I fetch through the cursor my cursor pointer is at the last record of the cursor.
so when I pass this cursor to the application I get NO RECORDS found.
4)To solve this problem I tried using DYNAMIC PL/SQL.
5)with dynamic PL/SQL I dont need to close the cursor and open it again.
6)But the problem is using the cursor handle I need to create a cursor and pass the cursor to an application.
Any help on this matter will be great.
Regards
Joseph