How to Create and Use CallableStatement Objects

How to Create and Use CallableStatement Objects

A CallableStatement object provides a standard way for all RDBMS’ to call stored procedures. A stored procedure is stored in a database; the call to the stored procedure is what a CallableStatement object contains. This call is written in an escape syntax that can take one of two forms: with a result parameter, and the other without one. A result parameter, a kind of OUT parameter, is the return value for the stored procedure. Both forms may have a variable number of parameters used for input (IN parameters), output (OUT parameters), or both (INOUT parameters). A question mark serves as a placeholder for a parameter.

Creating a CallableStatement object:

 CallableStatement callStmt = con.prepareCall(	"{call getData(?, ?)}");

The variable callStmt contains a call to the stored procedure getData, which has two input parameters and no result parameter. Whether the “?” placeholders are IN, OUT, or INOUT parameters depends on the stored procedure getTestData.

Suppose getTestData accepts two OUT parameters. Then you have to register the OUT parameter:

 cstmt.registerOutParameter(1, java.sql.Types.TINYINT);cstmt.registerOutParameter(2, java.sql.Types.DECIMAL, 3);

This is how to get it back:

 byte x = cstmt.getByte(1);
See also  Is Machine Learning Automating Creativity in Graphic Design?

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist