Venu,
ICST, S Portland
ME, USA.
Hi,
Here i am giving the small example for callable statements. I think it may
helpful to u. Here test2 is stored procedure having two parameters.
Connection con;
CallableStatement cs;
public void conn()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:scottDsn","scott","tiger");
cs = con.prepareCall("{? = CALL test2(?,?)}");
cs.registerOutParameter(1,Types.INTEGER);
cs.setInt(2,3);
cs.setString(3,"st");
cs.execute();
----- Original Message -----
From: "Mahesh Patil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 06, 2000 3:59 PM
Subject: Using CallableStatements
>
> Hi there,
> Has anyone used Callable Statements ???
> Can anybody please send me an example on how to use callable statements
for
> calling 'Stored Procedures'.
>
> Thanks,
> Mahesh
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
