aspose file tools*
The moose likes JDBC and the fly likes Store Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Store Procedure" Watch "Store Procedure" New topic
Author

Store Procedure

Abhay Tanaya
Greenhorn

Joined: Feb 03, 2009
Posts: 8
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

Joined: Sep 01, 2005
Posts: 182
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.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Store Procedure