GeeCON Prague 2014*
The moose likes JDBC and the fly likes Java wrappers over the PL/SQL packages Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java wrappers over the PL/SQL packages" Watch "Java wrappers over the PL/SQL packages" New topic
Author

Java wrappers over the PL/SQL packages

viswanath sigamala
Greenhorn

Joined: Feb 06, 2007
Posts: 11
Hi

How to write Java wrappers over the PL/SQL packages

Pls help me.

Thanks,
Visu
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2501
    
    8

CallableStatement cs1 = conn.prepareCall ("{call proc (?,?)}");
CallableStatement cs2 = conn.prepareCall ("{? = call func (?,?)}");

Where proc is the name of a stored procedure, and func is the name of a stored function.

More info from Oracle: http://download-west.oracle.com/docs/cd/B19306_01/java.102/b14187/chseven.htm#CACJDIAC

Good doc from MySQL on calling stored procedures (more detail):
http://dev.mysql.com/doc/refman/4.1/en/connector-j-usagenotes-basic.html#connector-j-usagenotes-statements-callable
Regards, Jan
[ April 23, 2007: Message edited by: Jan Cumps ]

OCUP UML fundamental and ITIL foundation
youtube channel
 
GeeCON Prague 2014
 
subject: Java wrappers over the PL/SQL packages