3 Replies Latest reply: Mar 7, 2012 6:45 PM by 922477 RSS

    Error executing MS sql server procedure

    904040
      I am getting an error below while executing a SQL server procedure from SOA composite. My jdeveloper and Soa Suite version is 11.1.1.4.
      I am using “Oracle’s MS SQL Server Driver (Type 4) Version: 7.0 and later” driver. The SQL Server version is 2005.
      To configure the connection I used the steps mentioned in URL below.

      http://beatechnologies.wordpress.com/2011/01/31/creating-a-dbadapter-for-mssql-server-in-osb-11g/

      The MS SQL procedure signature is as below.

      @p_EventId               nvarchar     IN
      @p_EventName_IN               nvarchar     IN
      @p_Agreement_No_IN          decimal          IN
      @p_Acc_Base_Number_IN          decimal          IN
      @p_Acc_Comp_No_IN          decimal          IN
      @p_Account_Company_Name_IN     nvarchar     IN
      @p_Agree_Stat_Code_IN          nvarchar     IN
      @p_Agree_Type_Code_IN          nvarchar     IN
      @p_HeadQtr_Code_IN          nvarchar     IN
      @p_Sales_Off_Name_IN          nvarchar     IN
      @p_Reseller_Name_IN          nvarchar     IN
      @p_Oracle_Order_number_IN     decimal          IN
      @p_License_Effective_Date_IN     datetime     IN
      @p_PO_Number_IN               decimal          IN
      @p_Invoice_Number_IN          decimal          IN
      @p_Invoice_Date_IN          datetime     IN
      @p_Support_Contract_ID_IN     decimal          IN
      @p_Stmt_Of_Capacity_Due_Date_IN     datetime     IN
      @p_Contract_Start_Date_IN     datetime     IN
      @p_Contract_End_Date_IN          datetime     IN
      @p_Contract_Type_IN          nvarchar     IN



      Error message .

      <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 'CompanySPProdcall' failed due to: Unimplemented object conversion. Conversion of type 1 whose JDBC type is OTHER to a Java object is not supported. An attempt was made to convert type 1 to a Java object using an unsupported JDBC type: OTHER. Use a data type with a supported JDBC type. ". 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>Unimplemented object conversion. Conversion of type 1 whose JDBC type is OTHER to a Java object is not supported. An attempt was made to convert type 1 to a Java object using an unsupported JDBC type: OTHER. Use a data type with a supported JDBC type. </detail>
      </part>
      <part name="code">
      <code>null</code>
      </part>
      </bindingFault>
      </bpelFault>
      </fault>

      Please let me know the solution for this issue?

      Thanks...