2 Replies Latest reply: Oct 8, 2010 3:22 AM by user8695019 RSS

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

    user8695019
      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