• 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

examples for stored procedures

 
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Any examples on using OUT and IN OUT parameter for stored procedures.Using
Java with oracle8i.Thanx
 
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 Clyde,
The following Web page has an example. Although it talks about Oracle 9i, I'm fairly sure that it will work for Oracle 8i as well.
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/basic/plsqlSample/Readme.html
There are also examples in the Oracle documentation, which can be accesses from
http://tahiti.oracle.com
And you can also try searching the "Ask Tom" Web site
http://asktom.oracle.com
Good Luck,
Avi.
 
clyde melly
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanx.Worked on stored procedures yesterday,but having problem with functions when using in java.The function gets created,but when called in the java program,the program gives an error on runtime
 
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
You have problem in calling an Oracle function from java? Can you explain bit more?
-Sainudheen
 
clyde melly
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have created a function in oracle which basically updates or does an insert with retrning a value.Now when i call it in java,i dont get the return value.Any examples on java calling the function along with the created function will be of immense help.thanx
 
Sainudheen Mydeen
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
How do you call your oracle function from java. Can you post the code?
-Sainudheen
 
clyde melly
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Now the code works up.Just had to read thru some tutorials and help and everything works up fine.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic