This discussion is archived
2 Replies Latest reply: Oct 8, 2010 1:22 AM by user8695019 RSS

Error while testing SOA sample adapters-db-101-File2StoredProcedure

user8695019 Newbie
Currently Being Moderated
Dear all,

I am testing SOA application adapters-db-101-File2StoredProcedure from SOA samples and I got the error:


<messages>
<input>
<Invoke_API_AddCustomers_InputVariable>
<part name="InputParameters">
<InputParameters>
<C>
<C_ITEM>
<FNAME>John</FNAME>
<LNAME>Doe</LNAME>
<LOC>
<STREET>123 Main Street</STREET>
<CITY>Anytown</CITY>
<STATE>CA</STATE>
<ZIP>12345</ZIP>
</LOC>
<EMAIL>john.smith@gmail.com</EMAIL>
<PHONE>567-123-9876</PHONE>
</C_ITEM>
<C_ITEM>
<FNAME>Jane</FNAME>
<LNAME>Doe</LNAME>
<LOC>
<STREET>987 Sunset Blvd</STREET>
<CITY>Sometown</CITY>
<STATE>CA</STATE>
<ZIP>34567</ZIP>
</LOC>
<EMAIL>JaneDoe@yahoo.com</EMAIL>
<PHONE>567-123-9876</PHONE>
</C_ITEM>
</C>
</InputParameters>
</part>
</Invoke_API_AddCustomers_InputVariable>
</input>
<fault>
<bpelFault>
<faultType>0</faultType>
<bindingFault>
<part name="summary">
<summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'AddCustomers' failed due to: Stored procedure invocation error. Error while trying to prepare and execute the ADD_CUSTOMERS API. An error occurred while preparing and executing the ADD_CUSTOMERS API. Cause: java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary>
</part>
<part name="detail">
<detail>ORA-00902: invalid datatype </detail>
</part>
<part name="code">
<code>902</code>
</part>
</bindingFault>

Does anybody tried to execute this sample?

Best regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points