java oracle cusor is closed where cursor is not return to jdbc
Posted
by
optimus
on Stack Overflow
See other posts from Stack Overflow
or by optimus
Published on 2012-10-10T15:34:24Z
Indexed on
2012/10/10
15:36 UTC
Read the original article
Hit count: 149
I am executing a stored procedure which has 2 cusors within the stored procedure.
The 1st cursor which is not return to the jdbc as a resultset is closed within the stored procedure.
The 2nd cursor which returns the resultset to the jdbc is not closed within the stored procedure.
Upon executing I encounter cursor is closed exception which is puzzling.
Since the ResultSet will close all underlying cursor upon invoking the close() method
© Stack Overflow or respective owner