Forum Stats

  • 3,827,034 Users
  • 2,260,734 Discussions
  • 7,897,150 Comments

Discussions

DB Adapter 902 binding exception while passing parameters for simple string

493866
493866 Member Posts: 198
Hi,

I have an PlSQL API with two input paramters of string type... But this is only started after XML validation TRUE on the BPM server.


The error is
<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="code"><code>902</code>
</part><part name="detail"><detail>
Internal Exception: java.sql.SQLException: ORA-00902: invalid datatype
Error Code: 902</detail>
</part><part name="summary"><summary>file:/oracle/product/10.1.3/soa/bpel/domains/Website/tmp/.bpel_BPELProcess1_1.0_c64929dfd2dacf95db3c9da081c1797d.tmp/callingAPI.wsdl [ callingAPI_ptt::callingAPI(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'callingAPI' failed due to: Error while trying to prepare and execute an API.
An error occurred while preparing and executing the XXRBA.XXRBA_WEB_ADAPTER.FETCH_CUSTOMERS API. Cause: java.sql.SQLException: ORA-00902: invalid datatype
[Caused by: ORA-00902: invalid datatype
]
; nested exception is:
ORABPEL-11811
Error while trying to prepare and execute an API.
An error occurred while preparing and executing the XXRBA.XXRBA_WEB_ADAPTER.FETCH_CUSTOMERS API. Cause: java.sql.SQLException: ORA-00902: invalid datatype
[Caused by: ORA-00902: invalid datatype
]
Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
</summary>
</part></bindingFault>




The input XSD parameters in BPEL input
-----------------------------------------
<element name="input" type="string"/>

The input XSD parameters in ADAPTER
------------------------------------------------------
<element name="P_WEB_ACCOUNT" type="string" db:index="1" db:type="VARCHAR2" minOccurs="0" nillable="true"/>
<element name="P_SOLICITED_ONLY" type="string" db:index="2" db:type="VARCHAR2" minOccurs="0" nillable="true"/>


The assignment I am doing in the .bple file is
----------------------------------------------------------
<assign name="Assign_1">
<copy>
<from expression="bpws:getVariableData('inputVariable','payload','/client:BPELProcess1ProcessRequest/client:input')"/>
<to variable="Invoke_1_callingAPI_InputVariable" part="InputParameters"
query="/ns2:InputParameters/ns2:P_WEB_ACCOUNT"/>
</copy>
<copy>
<from expression="string('o')"/>
<to variable="Invoke_1_callingAPI_InputVariable" part="InputParameters"
query="/ns2:InputParameters/ns2:P_SOLICITED_ONLY"/>
</copy>
</assign>



--Khaleel
Tagged:
This discussion has been closed.