Response from Oracle (Full Version)

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters



Message

shamir.ali -> Response from Oracle (9 January 2007)


Hello,

I have got a response from Request-Response communication port by requesting a select query.

Now a few of the fields that i have promoted in that response schema, when theres no records in the database for that specific select clause that i requested for, it gives an error, Infact it stops in the middle of the orchestration.

Text = SqlResponseMsgService(PropertySchema.ABC)

How can i resolve this issue.
 



Pieter -> RE: Response from Oracle (10 January 2007)

Another alternative would be to use the XPath function and perform a count() in the XPath Query, here you can simply look for the parent node of the field.

If the value returned is 0, then you know the fields don;t exist, otherwise it does exist and you can access the values.

Thisk this would be a pretty elegant solution.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875