Uploaded February 2017 | Updated November 2026, 16 hours ago
This video explains how to invoke Stored Procedures having IN and OUT mode paramameters using CallableStatement.
The method void registerOutParameter(int parameterIndex,int sqlType) can be used to specify a parameter in out mode [in java code]. Later, the parameter can be accessed based on the postion using getInt(pos) or getString(pos) or simple get[Type](pos)
CallableStatements created using prepareCall(String call) from java.sql.Connection. The parameter is of the following form
= {call function_name(?)} =
This tutorial series covers following topics
■ Connecting Java Program to MySQL Database
■ Inserting data into database
■ Fetching data from database
■ Updating an entry in database
■ Deleting an entry from database
■ Creating a table programmatically
■ Using PreparedStatements
■ Display database contents in JTable
■ Calling stored procedures
■ JDBC Batch operations
- Genuine Coder
genuinecoder.com
This video explains how to invoke Stored Procedures having IN and OUT mode paramameters using CallableStatement.
The method void registerOutParameter(int parameterIndex,int sqlType) can be used to specify a parameter in out mode [in java code]. Later, the parameter can be accessed based on the postion using getInt(pos) or getString(pos) or simple get[Type](pos)
CallableStatements created using prepareCall(String call) from java.sql.Connection. The parameter is of the following form
= {call function_name(?)} =
This tutorial series covers following topics
■ Connecting Java Program to MySQL Database
■ Inserting data into database
■ Fetching data from database
■ Updating an entry in database
■ Deleting an entry from database
■ Creating a table programmatically
■ Using PreparedStatements
■ Display database contents in JTable
■ Calling stored procedures
■ JDBC Batch operations
- Genuine Coder
genuinecoder.com










