Hi,
How do we get the result set from an oracle stored procedure in
Java? We are using Oracle 8.1.7. I am able to get the out parameters by passing some in parameters. But the result set is always returning �null�.
Is there any specific way to create stored procedure in Oracle for same purpose?
I am using oracle thin driver.
Currently we are writing the stored procedure as declaring a cursor for a simple select statement and let the curser open at the end of the stored procedure.
We already tried for just writing the select statement also to get the result set.
Will appreciate any help or direction or book or link to work on the same problem asap.
Vijay
SCJP, SCJD, SCWCD1.4, IBM486, IBM484, IBM 483, IBM 287, IBM141, IBM Certified Enterprise Developer - WebSphere Studio, V5.0
Author of IBM 287 Simulator Exam