//calling function
import java.sql.*;
class MyFunction
{
public static void main(String arg[])
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","student","student");
CallableStatement cs=c.prepareCall("{?=call SUM1(?,?)}");
cs.setInt(2,10);
cs.setInt(3,40);
cs.registerOutParameter(1,Types.INTEGER);
cs.execute();
int a=cs.getInt(1);
System.out.println("value="+a);
}
catch(Exception e)
{
System.out.println(e);
}
}
}
import java.sql.*;
class MyFunction
{
public static void main(String arg[])
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","student","student");
CallableStatement cs=c.prepareCall("{?=call SUM1(?,?)}");
cs.setInt(2,10);
cs.setInt(3,40);
cs.registerOutParameter(1,Types.INTEGER);
cs.execute();
int a=cs.getInt(1);
System.out.println("value="+a);
}
catch(Exception e)
{
System.out.println(e);
}
}
}
No comments:
Post a Comment