This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 1121

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
 
Consider Paul's rocket mass heater.
 
subject: Oracle Java Stored Procedure ... Urgent help needed.
 
Similar Threads
getting the resultset of a stored procedure?
Calling a stored procedure for MSSQL 2000?
cursor?
Oracle Stored Procedure Problem...
java stored procedure problems