Not sure if the title gives a good explanation of the issue I have.
I'm using OSB 12.2.1.2
What I'm trying to achieve is a common error handler for my Business Services that calls a number of different PL/SQL procedures in my database. I want to create an OSB template that has all the error management completed for the developers. The issue I have is for each Business Service - implementing a DB JCA Adapter has a different namespace for each Business Service.
The procedures use the same data structure to return the status of the procedure, i.e.
<Payload>
<ID>7324628<</ID>
<Name>James</Name>
<Address1>1 Main St</Address1>
...
<O_RESULT>
<STATUS>FAIL</STATUS>
<ERROR_STACK>
\<ERROR\_CODE>OSB-0248\</ERROR\_CODE>
\<ERROR\_MSG>Just a test Fail\</ERROR\_MSG>
</ERROR_STACK>
<O_RESULT>
The bottom O_RESULT is the same in all my stored procedures. The issue is the Business Service puts a name space on the schema, i.e. http://xmlns.oracle.com/pcbpel/adapter/db/sp/myBusinessExample.
If I add that namespace to my xquery it works, however only for pipelines that call out to MyBusinessExample. I want to map that O_RESULT snip it into a variable flexible enough to handle any business service.
Adding namespace to the resource does not work either as you can only do this in the template, you cant edit in the actual pipeline.
I have tried to use the following command but I think I'm using it wrong. Hopefully it explains what I'm after:
fn:local-name($body/OutputParameters/O_RESULT/STATUS)
I was hoping this command would just search for the XML path regardless of the namespace. When I run it, I get back a blank.
I hope someone can help
cheers
James