Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Store Procedure

 
Abhay Tanaya
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I need one help regarding use of store procedure in oracle. My problem is, I have converted java code to store procedure. When we run insert query thro' java we get result set. And by checking return value we update same row. But how we can do it in store procedure? After insertion query i have to run update query. So how I can do this in store procedure.

Thanks
Abhay
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Abhay,

What do you mean by "store procedure"? Is it "stored procedure"?
Do you want to use java inside pl/sql?

If so
1) You created your java source
2) Mapped your java method to a pl/sql function/procedure
3) call the function/procedure

If you are asking passing in and out parameters to java stored procedures then this may help. First check out the tutorials, then samples.

Regards,

Fatih.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic