Structure of stored procedure

[Former Member]

Hi Experts,

We have interace from EDI 945 to Stored procedure

We will get 945 file from customer and we have to call stored procedure to update those in to data base.

File to JDBC is the scennario. Can you help me to craete datatype for the attached target structure and what action i need to use to call stored procedure, is it "Execute", I never worked on stored procedures so got these many questions.

[nabendu_sen]

Hi Sruthi,

The stored procedure structure should be like below:

<StatementName5>

<storedProcedureName action=” EXECUTE”>

  <table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

  </StatementName5>

Reference: Document Formats for the Receiver JDBC Adapter - SAP NetWeaver Exchange Infrastructure - SAP Library

You can find more details in the below blog of

Regards,

Nabendu.

[former_member184720]

Did you check the below blog.