Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stored Procedure

Hi all,

I am new to this concept: Stored Procedure

what is Stored Procedure ?

why we use Sotred procedure?

what actions need to be taken care for DB and JBDC adapter( sender / reciver) side?

Really appreciate your response?




<b>what is Stored Procedure ?</b>

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

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:

The Store procedure converts the table resulting from the query SQL statement into a valid XML document and sends it to the Integration Engine. The document looks like this:













<b>why we use Sotred procedure?</b>

store procudeure are used to retrive the datas from DB which are in Table format into XML format.

<b>what actions need to be taken care for DB and JBDC adapter( sender / reciver) side?</b>

HTTP to stored Procedure(JDBC) scenario.


File to File scenario(store procedure implemented)


Also check

Check this Blog


refer these links


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





Use a Good Subject Line, One Question Per Posting - Award Points

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question