Commit issued without hold and without close cursor statemen

[ravi11081992]

Hi,

If I use 'cursor without hold' and
after fetching all the records if I issue commit without having a 'Close cursor' statement

Will it be an issue opening the cursor again when I run the program again

Please let me know

Thanks

[prino]

Why the flipping 'ell don't you try with a test program?

[engh]

in case the answer is still awaited : yes, closing the cursor like committing the transaction causes the cursor pointer to be lost.
There is therefore no other solution than to specify "with hold" to avoid this inconvenience.