View previous topic :: View next topic
|
Author |
Message |
CUDNAREN
New User
Joined: 06 Jan 2006 Posts: 9
|
|
|
|
HI ALL
CAN ANYBODY TELL ME WHAT HAPPENS WHEN IAM FECTHING 1000 RECORDS AND AT 500TH RECORD ABEND OCCURS AND I HAVE DECLARED A CURSOR WITH WITHHOLD OPTION.HERE AT THIS STAGE WHETHER THE CURSOR WILL BE IN OPEN STAGE OR SINCE ABEND OCCURED IT WILL BE CLOSED.
PLS TELL ME WHETHER CURSOR WILL BE OPENED OR CLOSED WHEN ABEND OCCURS. |
|
Back to top |
|
|
KMK
New User
Joined: 29 Jul 2005 Posts: 18
|
|
|
|
Hi
WITH HOLD option is used to hold the result set only if COMMIT is issued.
But when the program abends , the cursor will be closed implicitly, I think
Cheers, |
|
Back to top |
|
|
pa1chandak Currently Banned New User
Joined: 31 Jan 2006 Posts: 55
|
|
|
|
it will be open because of with hold option
pawan |
|
Back to top |
|
|
nuthan
Active User
Joined: 26 Sep 2005 Posts: 146 Location: Bangalore
|
|
|
|
WITH HOLD specifies that the cursor may continue to be used after the transaction that created it successfully commits.
If WITH HOLD is specified and the transaction that created the cursor successfully commits, the cursor can continue to be accessed by subsequent transactions in the same session. (But if the creating transaction is aborted, the cursor is removed.) A cursor created with WITH HOLD is closed when an explicit CLOSE command is issued on it, or the session ends |
|
Back to top |
|
|
|