*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 2491
    
    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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java wrappers over the PL/SQL packages
 
Similar Threads
How to write Java wrappers over the PL/SQL packages
xml file from db
learning Ant
WA #1.....word association
How to check which version of Oracle