How can we execute stored procedures?
Answer / Arjun Kumar Sharma
To execute a stored procedure in JDBC, you can use the createStatement() or prepareStatement() methods to create a CallableStatement object. Then, set the parameters (if any), call the execute() method with CALL as the statement type, and retrieve the result using getResultSet(), getUpdateCount(), or getObjects(). Example: CallableStatement cs = con.prepareCall("{call myProcedure}");
| Is This Answer Correct ? | 0 Yes | 0 No |
What are jdbc and its components?
What is database connection pooling? Advantages of using a connection pool?
what exactly happens when we execute "Class.forname("Driver class name");"?Explain indetail
10 Answers Accenture, HP, IBM, Infosys, SAP Labs, SAS, Sasken, Trigent, Wipro,
What is the role of class.forname while loading drivers?
Explain about the Try Block?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
What are the classes and methods used for sending sql statements to database?
What are the ddl statements?
Explain the difference between inner and outer join ?
What is jdbc thin client in oracle?
What is the difference between ojdbc6 and ojdbc7?
Is jdbc connection secure?