wood burning stoves 2.0*
The moose likes JDBC and the fly likes Oracle Java Stored Procedure ... Urgent help needed. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Java Stored Procedure ... Urgent help needed." Watch "Oracle Java Stored Procedure ... Urgent help needed." New topic
Author

Oracle Java Stored Procedure ... Urgent help needed.

Vijay S. Rathore
Ranch Hand

Joined: Oct 29, 2001
Posts: 449
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
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

Hi Vijay,
I think this Web page may be useful (assuming you haven't already seen it :-)
http://osi.oracle.com/~tkyte/ResultSets/index.html
Hope it helps.
Good Luck,
Avi.
Vijay S. Rathore
Ranch Hand

Joined: Oct 29, 2001
Posts: 449
Hi Avi,

Once again thanks Avi. If you don't remember you answered one more query earlier.
You are the man.
Will bother you again if anything else come up in ORACLE.

Vijay
 
jQuery in Action, 2nd edition
 
subject: Oracle Java Stored Procedure ... Urgent help needed.