return parameter of store procedure

[former_member184166]

Hi,

Scenario Synchronic

I'm have un Messages Type that call an store procedure in oracle.

This store procedure return an parameter that indicate if the insert it's ok or not (0: Ok, 1: Not Ok).

It's possible create an Message Type that i'm program how an receiver adapter and process the parameter?.

Regards,

[Former Member · Accepted solution]

Check out the documentation at:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

The documentation clearly says that "All return values are returned in an XML structure."

From my experience with the JDBC adapter, the response message has the same name as the query message, concatenated with _response.

For example if your outbound message type is MtMyMessage,

the returned message is MtMyMessage_response.

[former_member184166 · Accepted solution]

thank's Ofer...

I see that the tag i'm need is the <insert_count>count</insert_count>

and i have to define the msesage type (sender) the param isOutput in true.

Regards

[Former Member]

Hi,

Please can you have a look at this weblog.

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

Regards

vijaya

Message was edited by: vijaya kumari

[former_member184166]

Hi,

This scenario return an resulset (SELECT), but oracle not return an resulset..

I need return an parameter (number) and process it because is an INSERT sentence.

Thanks