Stored procedure problem

[Former Member]

Hi,

I have a file to jdbc syn scenario, where at source we have file data that is supplying input paramenter to jdbc stored procedure at target and execute stored procedure then stored procedure create response as a output based on input parameter.

i am not able to get the response from the stored procedure.

I have done all related mapping with request and response.

Payload

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_SP_JDBC xmlns:ns0="http://ns_jdbctest">

- <GetNextSiteNumberTEST>

- <row action="execute">

<table>GetNextSiteNumberTEST</table>

<SiteId IsInput="true" type="integer">1</SiteId>

<NextnoId IsInput="true" type="varchar">Table.TESTSP</NextnoId>

<Result IsOutput="true" type="integer">Result</Result>

</row>

</GetNextSiteNumberTEST>

</ns0:MT_SP_JDBC>

please let me know the possibliliy.

Regards

Laxmi Bhushan

Edited by: laxmi bhushan on Sep 21, 2010 4:43 PM

Edited by: Prateek Raj Srivastava on Sep 21, 2010 5:28 PM

[Former Member]

Hi Lakshmi Bhusan,

You please check with your request message type and response message type structure

It should be the below format,

for ex: Request Message type:

MT_StoredProc_Req

--StatementName

your Response Message type should be:

MT_StoredProc_Req_response

--StatmentName_response

and also please check your BPM.

Thank you

Sateesh

[Former Member]

yes i have same structure,

I have not used BPM, Is it require to have BPM .

Regards

Laxmi Bhushan

[prateek]

File does not support sync calls and therefore the call made to database are async. You may either use BPM or check out for standard adapter modules usage (RequestResponseBean and ResponseOneWayBean).

Regards,

Prateek

[Former Member]

Thanks for pointing out .

Actually i have fixed value for stored procedure and it does not require any file data , i can put constant value to input parameter of stored procedure.

lets say it is jdbc to jdbc scenario,

at DT_request there is some dummy structure i have created and in inbound is JDBC adapter that is executing the stored procedure where i have put constant value to input parameter , and it is executing the stored procedure with output parameter and populating the output value in DataBase.

Now i am not able to get those response data from the output parameter.

My Stored procedure execute like this. where first two is input paramenter and last one is output parameter.

declare @Result int

Exec GetNextSiteNumberTest 1, 'Table.TESTSP', @Result OUTPUT

select @Result

Please suggest how to create the scenario.

Regards

Laxmi Bhushan