Drop Down

Tuesday, April 9, 2019

Procedure Call

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();

}

}

No comments:

Post a Comment

Java 8 Notes Pics