File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling stored procedures from Java
 
Similar Threads
Stored Procedures and Session Ejb
List Updation
writing log to a file from java stored procedure
how to run
Exception handling for stored procedure from Java code