Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"java.sql.SQLException: Ref cursor is invalid" - Please help

413635Jan 29 2004 — edited Jan 29 2004

Hi everyone,

I'm really having problem. I'm surrently calling a PL/SQL stored procedure from Java but I'm getting the following error:

java.sql.SQLException: Ref cursor is invalid

The procedure has 2 normal IN parameters and 1 ref cursor OUT parameter. Depending upon Parameter 1 a ref cursor may or may not be initialised.

If Parameter 1 is "yes" then a ref cursor is called to retrieve some data and passed into the OUT. If Parameter 1 is set to "no" then the ref cursor is not initialised. It is here where the error is being hrown. Does anyone know why? Microsoft ADO doesn't seem to complain. Please help is needed. Thanks in advance.

John

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2004

Added on Jan 29 2004

#general-database-discussions

6 comments

468 views