• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java wrappers over the PL/SQL packages

 
viswanath sigamala
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

How to write Java wrappers over the PL/SQL packages

Pls help me.

Thanks,
Visu
 
Jan Cumps
Bartender
Posts: 2608
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic