• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Oracle Java Stored Procedure ... Urgent help needed.

 
Ranch Hand
Posts: 449
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic