stored procedure

[Former Member]

hi all,

what is the use of stored procedure,where it is used in jdbc,where dhould we write our code?

regards,

keerthi

[Former Member]

Hi,

What is Stored Procedure:

http://en.wikipedia.org/wiki/Stored_procedure

Instead of "SQL Statement" you can mentioned the name of stored procedure. For example instead of writing updation code in SQL statement section you can use a stored procedure for the same purpose.

Check this SAP file (<SQL-Select-Statement> and <SQL-Select-Statement>) sections:

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

Regards,

Subhasha

[Former Member]

Hi keerthi !!

Check this Blog

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

refer these links

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Also, you can check Sriram's blog for executing Stored Procedures,

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

This blog might be helpfull on stored procedures for JDBC

JDBC Stored Procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Please go through these threads and see if it helps...

Thanks !!

[former_member192892]

Hi Keerthi,

Stored proceedures are precompiled piece of SQL code writetn on your DB..

http://www.functionx.com/sqlserver/Lesson16.htm