Java code:
Package procedure;
Import java. SQL. CallableStatement;
Import java. SQL. Connection;
Import java. SQL. DriverManager;
Import java. SQL. ResultSet;
Import java. SQL. SQLException;
Import java. SQL. Statement;
Public class TestProcedureOne {
Public TestProcedureOne (){
}
Public static void main (String [] args ){
String driver = "oracle. jdbc. driver. OracleDriver ";
// Oracle. jdbc. driver. OracleDriver
String strUrl = // "jdbc. oracle: thin: @ 127.0.0.1: 1521: ORCL ";
"Jdbc: oracle: thin: @ 127.0.0.1: 1521: orcl ";
ResultSet rs = null;
Connection con = null;
Try {
Class. forName (driver );
Con = DriverManager. getConnection (strUrl, "username", "password ");
CallableStatement proc = null;
Proc = con. prepareCall ("{call TESTA (?,?)} ");
Proc. setString (1, "firstName ");
Proc. setString (1, "77.77 ");
Proc.exe cute ();
} Catch (SQLException ex2 ){
Ex2.printStackTrace ();
} Catch (Exception ex2 ){
Ex2.printStackTrace ();
} Finally {
Try {
If (rs! = Null ){
Rs. close ();
If (con! = Null ){
Con. close ();
}
}
} Catch (SQLException ex1 ){
}
}
}
}
Stored Procedure:
Create or replace procedure testa (PARA1 IN VARCHAR2, PARA2 IN VARCHAR2)
BEGIN
Insert into book (Bookname, BOOKPRICE) VALUES (PARA1, PARA2 );
End testa;