• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Java Stored Procedure ... Urgent help needed.

 
Vijay S. Rathore
Ranch Hand
Posts: 449
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 449
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic