Synchronous call to Stored Procedure

[Former Member]

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

[bhavesh_kantilal · Accepted solution]

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

[Former Member · Accepted solution]

Hi Bhavesh,

I have tried this. but in my response message, am getting one more complex element: <response_1>

<update_count>1</update_count>

</response_1>

Even that's fine; but I need to do some processing on the SP response. When I include the response message in a message mapping, it throws exception at runtime. Is it not possible to perform processing on the response? if , how? Please do reply

Thanks

Chilanka

[bhavesh_kantilal · Accepted solution]

Hi,

Check the Stored Procedure Response data fromat that causes the exception with your Datatyppe / MessageType created for the response.

This should confirm to the strcuture of the response of the stored procedure. Make sure this is done.

Regards

Bhavesh

[Former Member · Accepted solution]

Thank You Bhavesh.. it's done

[bhavesh_kantilal · Accepted solution]

What was the problem? Was it that the messagetype was not as per the SP's response?

Regards

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Yeah .. there was a mismatch between the message type and the SP response ..

ThankYou

[Former Member]

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