package jdbc;
import java.sql.*;
public class ProcedureCall_Salary {
public static void main(String[] args) throws SQLException , ClassNotFoundException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
CallableStatement cst =con.prepareCall("{call proc_getsal(?,?)}");
cst.setInt(1,101);
cst.registerOutParameter(2,Types.INTEGER);
cst.execute();
//System.out.println("Salary is :"+cst.getInt(2));
con.close();
}
}
import java.sql.*;
public class ProcedureCall_Salary {
public static void main(String[] args) throws SQLException , ClassNotFoundException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
CallableStatement cst =con.prepareCall("{call proc_getsal(?,?)}");
cst.setInt(1,101);
cst.registerOutParameter(2,Types.INTEGER);
cst.execute();
//System.out.println("Salary is :"+cst.getInt(2));
con.close();
}
}
No comments:
Post a Comment