The Broad –level steps to use CallableStatement in an application are as follow:

1. Creating the CallableStatement object.

2. Setting the values of parameters.

3.  Registering the OUT parameter type.

4. Executing the stored procedure or function.

5. Retrieving the parameter values.

For Example: We have created two table (‘bank’  and ‘personal_details) in Oracle Database.Now, We want to create the procedure createAccount that can insert a records into both the tables .



Now, we  used this procedure in java program with the help of JDBC . We create a java file and write code are as follow:

import java.sql.*;

/**
* @author Anupam Mishra
*/
public class CallableStatementEx{
public static void main(String args[]) throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
//Step 1: get CallableStatement
CallableStatement cs= con.prepareCall("{call
createaccount(?,?,?,?,?,?)}");
//Step 2:set IN Parameters
cs.setInt(1,1001);
cs.setInt(2,10);
cs.setString(3,"Anupam");
cs.setDouble(4,10000);
cs.setString(5,"Allahabad");
cs.setInt(6,51663);
//Step 3: register OUT parameters
// In this program, we don't have OUT parameters
//Step 4:
cs.execute();
System.out.println("Account Created
Succesfully!..");
con.close();
}
}

The Output is shown Below:



  Modified On Dec-14-2017 01:37:05 AM

Leave Comment