Skip to Content
avatar image
Former Member

Response less Synchronous call.

Hi,

I have a Synchrnous call (stored procedure) to be executed from BPM, but I am not expecting any response.

How can I make this call to wait for 30 min or 40 min, or till its successful.

Thanks-in-advance.

/Raj.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 26, 2006 at 03:34 AM

    hi raj,

    <i>I have a Synchrnous call (stored procedure) to be executed from BPM, but I am not expecting any response.</i>

    You want to execute a stored procedure from a BPM using JDBC adapter and this will not return anythinmg . Also, you need to know if the execution of the Stored Procedure is succesful.

    In this case, you can configure your JDBC adapter synchronously and after the execution of the procedure, you will get a response back from the Database, cotainiong the number of rows updated and inserted.

    If you do not want any synchronous call to the JDBC, then, one way to make sure is that the stored procedure ios executed succesfully is to use ALERTS. If the process was to error in the JDBC adapter, the Alert would be triggered and you can send the email.

    Is this what you want or have i understood your requirements wrong?

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2006 at 10:05 AM

    check this out to call stored procs from xi

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

    Add comment
    10|10000 characters needed characters exceeded