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: