File to JDBC,How to Trigger Stored Procedure.

[Former Member]

Dear all,

The scenario is File to JBDC.

When I send the Employee infornation like Empno,Ename,Adress.,The Stored procedure must be triged and the employee information must be updated in the Employee table and ack must be received.

I Wrote a procedure to insert the emp details in to emp table.

How to call this Procedure?How can the Stored procedure can be triggered.

Thanks,

Srinivas

[prateek · Accepted solution]

This will also be helpful

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

Regards,

Prateek

[Former Member]

hi srinivas

refer this blog

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

regards

Ramesh P

[Former Member]

My Procedure name is Empl.

By Putting Action=Execute in the Structure as mentioned in 1671 log,How does the Adapter Recognise the Procedure.Can You please brief me?

Thanks,

Srinivasa

[Former Member]

hi srinivas,

refer for this to know about the execute method

http://help.sap.com/saphelp_nw04/helpdata/en/69/3769873336534f9b98c7439d978666/content.htm

regards

Ramesh P

[former_member192892]

Hi Srinivas, u need to use receiver jdbc adapter....The action you need to use is either EXECUTE or if you want to hard code the execute statement you should use SQL_DML

For more details

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm