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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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
 
Similar Threads
batch update in SQL
Stored Procedure inside HQL query?
sql query stored in the xml, parsed and executed from java - throws malformed exception
oracle store procedure taking a list of values at run time ?
Stored procedure call removes spaces in text