wood burning stoves 2.0*
The moose likes JDBC and the fly likes Calling stored procedures from Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Calling stored procedures from Java" Watch "Calling stored procedures from Java" New topic
Author

Calling stored procedures from Java

Sirisha Reddy
Ranch Hand

Joined: Jun 09, 2003
Posts: 75
Is there a way to call a stored procedure and other PL/SQL block that reside in Oracle server, from a java program.
Thanks.


SCJP 1.4
Pavel Halas
Ranch Hand

Joined: Jul 05, 2003
Posts: 35
Yes. The way is simple. You'll create new statement with something like "begin procedureName() end;".
Pavel Halas
Ranch Hand

Joined: Jul 05, 2003
Posts: 35
You'll better follow this...
Java JDBC tutorial
This is warranted.
Sujatha Ranganathan
Greenhorn

Joined: May 29, 2003
Posts: 12
You will find lot of sample code that demonstrate invoking stored procedures from JDBC here
 
Consider Paul's rocket mass heater.
 
subject: Calling stored procedures from Java