Idoc to Jdbc using stored procedure

[Former Member]

Greetings All,

In my scenario i want to send the idoc from SAP system to SQL database using the stored procedure. I want ack back from JDBC adapter when the record is sucessfully inserted in DB table. There after i can update the status of idoc sent in source SAP system. Can anyone suggest me how to achive this since its seems to like a syncronous scenario. Can we achive this without stored procedure i.e. calling Insert_Update statement

Many thanks,

Sandip

[stefan_grube]

When you just want to set the Idoc status, use report IDX_NOALE, select your port and on next screen enter your Idoc message type and check "system OK" and "system error" only.

In sender system, maintain settings for ALEAUD (WE20) and then the Idoc status will go to 39 (success) or 40 (error)

[Shabarish_Nair]

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures this shall be a good start

[Former Member]

I have gone through this blog, but in my case wanted to send idoc to DB and i dont know how i could get response back from JDBC adapter since there is no such syncronous call.

Thanks,

Sandip

[Former Member]

Hi,

Go through this thread

Regards

Laxmi Bhushan