PROGRAM AND PROCEDURE WITH PARAMETER

SQL> create or replace procedure update_sal1
  (peno number) is
  begin
  update emp set sal=sal+100 where empno=peno;
  end;
  /

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Scanner;
public class Test16 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "rakesh");
CallableStatement cs = con.prepareCall("{call update_sal1 (?)}");
Scanner scan = new Scanner(System.in);
System.out.println("Input empno");
int eno = scan.nextInt();
cs.setInt(1,eno);
cs.execute();
}
}