This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

examples for stored procedures

 
clyde melly
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any examples on using OUT and IN OUT parameter for stored procedures.Using
Java with oracle8i.Thanx
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
Sainudheen Mydeen
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
  • Quote
  • Report post to moderator
Now the code works up.Just had to read thru some tutorials and help and everything works up fine.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic