Skip to Content
avatar image
Former Member

Stored procedure problem

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 21, 2010 at 11:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Prateek Raj Srivastava

      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