Hi guys, I got a question that hopefully you experts can help me. I got a scenario and using BPM like this: HTTP --> XI --> SAP --> XI --> ORACLE Storedprocedure.
For each XI communicating with 3rd party (HTTP, SAP, ORACLE) , i'm using synchronous call. For each those synchcronous call in BPM, i also already provide an exception branch. The problem is, when there is an exception occurs when calling the ORACLE storeprocedure (see error below), it doesn't go to my exception branch. Anybody know why?
the Error is:
http://sap.com/xi/XI/Message/30" xmlns:SOAP=" http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">
<SAP:Category>XIAdapterFramework</SAP:Category>
<SAP:Code area="MESSAGE">GENERAL</SAP:Code>
<SAP:P1 />
<SAP:P2 />
<SAP:P3 />
<SAP:P4 />
<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PROCSAPDSTMM030' (structure 'StatementName'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROCSAPDSTMM030' ORA-06550: line 1, column 7: PL/SQL: Statement ignored</SAP:AdditionalText>
<SAP:ApplicationFaultMessage namespace="" />
<SAP:Stack />
<SAP:Retry>M</SAP:Retry>
</SAP:Error>