| 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
|
 |
 |
|
|
subject: Calling stored procedures from Java
|
|
|