What are stored procedures? How to call them?

Answer Posted / subbu

A Stored procedure is a collection of sql statements that
are stored under a name & executed.when you create a stored
procedure all the steps like parsing,checking,compiling etc
are carried out.They can be called from java by using
prepareCall().

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store the file in the oracle database?

520


How to make updates to updatable result sets in jdbc?

490


Why do I have to reaccess the database for Array, Blob, and Clob data?

544


How to retrieve warnings in jdbc?

525


How do I load a database driver with JDBC 4.0 / Java 6?

555






What is addbatch jdbc?

533


How do I set properties for a JDBC driver and where are the properties stored?

494


I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?

483


Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

586


Which interface handles transaction management in jdbc?

566


How many locking systems are there in jdbc?

557


What does the jdbc resultsetmetadata interface?

552


What is serialization and deserialization in java programming?

522


How to set the attribute concurrency in resultset?

502


What is jdbc resultsetmetadata interface?

530