Java CallableStatement Interface

Last Updated : 9 Apr 2026

The CallableStatement interface is used in JDBC to call stored procedures and functions from a Java application. It helps in executing database logic that is already defined in the database.

In this chapter, you will learn about the CallableStatement interface, its usage, and how to call stored procedures and functions.

What is CallableStatement Interface?

The CallableStatement interface is used to call stored procedures and functions in a database. These procedures contain precompiled business logic, which improves performance and reduces code complexity.

For example, you can create a function in the database to calculate the age of an employee based on the date of birth, and then call it from a Java program using CallableStatement.

Difference Between Stored Procedures and Functions

The differences between stored procedures and functions are given below:

Stored Procedure	Function
is used to perform business logic.	is used to perform calculations.
must not have the return type.	must have the return type.
may return 0 or more values.	may return only one values.
We can call functions from the procedure.	Procedure cannot be called from function.
Procedure supports input and output parameters.	Function supports only input parameter.
Exception handling using try/catch block can be used in stored procedures.	Exception handling using try/catch can't be used in user defined functions.

Getting the Instance of CallableStatement

The prepareCall() method of the Connection interface is used to create an instance of CallableStatement.

Syntax:

This syntax is used to call a stored procedure with parameters.

Example:

The example to get the instance of CallableStatement is given below:

In this example, the procedure myprocedure is called with two parameters.

Example to Call the Stored Procedure Using JDBC

To call the stored procedure, you need to create it in the database. Here, we are assuming that stored procedure looks like this.

create or replace procedure "INSERTR"
(id IN NUMBER,
name IN VARCHAR2)
is
begin
insert into user420 values(id,name);
end;
/   

The table structure is given below:

In this example, we are going to call the stored procedure INSERTR that receives id and name as the parameter and inserts it into the table user420. Note that you need to create the user420 table as well to run this application.

import java.sql.*;
public class Proc {
public static void main(String[] args) throws Exception{

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");

CallableStatement stmt=con.prepareCall("{call insertR(?,?)}");
stmt.setInt(1,1011);
stmt.setString(2,"Amit");
stmt.execute();

System.out.println("success");
}
}

Now check the table in the database, value is inserted in the user420 table.

Example to Call the Function Using JDBC

In this example, we are calling the sum4 function that receives two input and returns the sum of the given number. Here, we have used the registerOutParameter method of CallableStatement interface, that registers the output parameter with its corresponding type. It provides information to the CallableStatement about the type of result being displayed.

The Types class defines many constants such as INTEGER, VARCHAR, FLOAT, DOUBLE, BLOB, CLOB etc.

Let's create the simple function in the database first.

create or replace function sum4
(n1 in number,n2 in number)
return number
is 
temp number(8);
begin
temp :=n1+n2;
return temp;
end;
/

Now, let's write the simple program to call the function.

import java.sql.*;

public class FuncSum {
public static void main(String[] args) throws Exception{

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");

CallableStatement stmt=con.prepareCall("{?= call sum4(?,?)}");
stmt.setInt(2,10);
stmt.setInt(3,43);
stmt.registerOutParameter(1,Types.INTEGER);
stmt.execute();

System.out.println(stmt.getInt(1));
		
}
}

Output:

Next TopicTransaction Management in JDBC

<<prev next>>

We deliver comprehensive tutorials, interview question-answers, MCQs, study materials on leading programming languages and web technologies like Data Science, MEAN/MERN full stack development, Python, Java, C++, C, HTML, React, Angular, PHP and much more to support your learning and career growth.