Return a parameter through stored procedures

[sabyasachi_mohapatra3]

Hello Experts

I want to return parameter through stored procedures so as to ensure that the application has been executed properly.

My source message format is

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

<table>Summarize_prc</table>

<empid [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</empid>

</storedProcedureName >

</StatementName5>

Do i need to put some extra parameters for return values from the stored procedures?

What would be the response message format to return the parameters from stored procedure.

Thanks

Sabyasachi

[Former Member · Accepted solution]

Hi,

If you wants to read the return values from stored procedure, the scanario should be designed as Sync.

The format looks like thsi

<Message Type Name>

      <STATEMENTNAME_response>
                  <Field1> </Field1>
                   ...............................
   </STATEMENTNAME_response>

</Message Type Name>

[sabyasachi_mohapatra3]

Answered

[Former Member]

go thru this blog, it will help.

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures