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

What is JDBC Batch Processing and what are it’s benefits?

577


What protocol does jdbc use?

603


What does the connection object represents?

640


What is odbc. how is it related to sql cli?

674


What are the different types of statements in jdbc?

576






What are restrictions on triggers?

1750


How to connect html page to database using jdbc?

562


Where is mysql jdbc driver located?

594


What is jdbc and why is it required?

558


What are the different types of lockings in jdbc?

582


What driver should I use for scalable Oracle JDBC applications?

590


Explain the steps in writing a java program using jdbc?

548


What do you understand by jdbc datasource?

670


What is a jdbctemplate?

600


What is connection commit?

588