Steps for creating connection with the database -


CallableStatement Interface -

CallableStatement interface inherits PreparedStatement interface. It is used to execute PL SQL Stored Procedures and functions.
We can get reference to CallableStatement by using prepareCall() method of Connection Interface. It has the following syntax -
CallableStatement prepareCall(String sql) throws SQLException

For example -
CallableStatement stmt=con.prepareCall("{call myprocedure(?,?)}");    
Like PreparedStatement CallableStatement can also take input at run time.