Skip to Content
avatar image
Former Member

Synchronous call to Stored Procedure

Hi all

Am new to Stored Procedures. I need to do an HTTP-JDBC scenario using SP(synchronous). My SP takes an output parameter 'flag' (along with the input parameters)and sets it to 0 or 1 depending on a condn. I need to get this value at my HTTP client. Could you please tell me what should be the structure of my SP response message and how should be the mapping done?

Thanks

Chilanka

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 16, 2007 at 04:27 AM

    Hi,

    The request message should look like,

    <root>

    <CallOracleProc>

    <storedProcedureName action>

    <table>

    <input element isInput type/>

    <outputElement isOutput type/>

    </table>

    </storedProcedureName>

    <CallOracleProc>

    </root>

    Response should be,

    <root_response>

    <CallOracleProc_response>

    <OutputElement/>

    </CallOracleProc_response>

    </root_response>

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2007 at 04:44 AM

    Hi-

    Check these links may be helpful to you....

    /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

    Add comment
    10|10000 characters needed characters exceeded