How To Call A Stored Procedure From Jdbc?

1.	How To Call A Stored Procedure From Jdbc?
Answer» The first step is to create a CALLABLESTATEMENT object. As with Statement an and PreparedStatement objects, this is done with an OPEN Connection object. A CallableStatement object CONTAINS a call to a STORED procedure. E.g. CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}"); The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure. E.g. CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");

Answer»

The first step is to create a CALLABLESTATEMENT object. As with Statement an and PreparedStatement objects, this is done with an OPEN Connection object. A CallableStatement object CONTAINS a call to a STORED procedure.
E.g.
CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.
E.g.
CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");

Discussion

No Comment Found

Related InterviewSolutions

What Is Unicastremoteobject?
What Is Inet Address?
What Does A Thread Enter When It Terminates Its Processing?
How To Deserialize Objects With Multiple References?
How To Serialize Objects With Multiple References?
What Is The Java.sql.timestamp Class?
How To Set A Parameter To Null?
How Applet Restrictions Affect Jdbc? Explain.
Explain The Sql?
What Is Relational Database?