View previous topic :: View next topic
|
Author |
Message |
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
Hi All,
My requirement is as below
1. Call a subprogram,open a cursor and fetch around 100 records from a table and write them in an Output file and then go back to main program
2. After performing logic in main program call the sub program again and start fetching table record from 101st record ands write them in same output file till end of cursor and then close the cursor
My doubts are as below:
1. Once I open the cursor will it remain open when I go back to the main program 1st time?
2. If cursor does not remain open can anyone please guide me how to process logic mentioned above?
Thanks in advance,
Regards,
Chandan |
|
Back to top |
|
|
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
Hi Guys,
After posting this posting I ram a sample program taking scenarios mentioned in program and its working fine we can have the cursor open and come back to main program and then again fetch from next record second time..
My apology for inconvenience
Regards,
Chandan |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
My apology for inconvenience |
If this was the very worst thing to happen this week, it would be a very good week
Thank you for posting your finding. It will help someone else one day
d |
|
Back to top |
|
|
|