locked
Error while Polling data through procedure in Oracle DB RRS feed

  • Question

  • Hi Help.

    We are getting the below error while polling the messages from Oracle DB,

    The adapter "WCF-Custom" raised an error message. Details "Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-06550: line 4, column 13:
    PLS-00302: component 'Customer' must be declared
    ORA-06550: line 4, column 2:
    PL/SQL: Statement ignored ---> Oracle.DataAccess.Client.OracleException: ORA-06550: line 4, column 13:
    PLS-00302: component 'Customer' must be declared
    ORA-06550: line 4, column 2:
    PL/SQL: Statement ignored
       at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
       at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
       at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper)
      --- End of inner exception stack trace ---
       at Microsoft.ServiceModel.Channels.Common.Channels.AdapterInputChannel.EndTryReceive(IAsyncResult result, Message& message)
       at System.ServiceModel.Dispatcher.InputChannelBinder.EndTryReceive(IAsyncResult result, RequestContext& requestContext)
       at System.ServiceModel.Dispatcher.ErrorHandlingReceiver.EndTryReceive(IAsyncResult result, RequestContext& requestContext)".

    Request your kind help on this issue ASAP.

    BR,

    Ali



    Wednesday, April 13, 2016 11:50 AM

Answers

  • It worked :).

    Oracle Client and Oracle DB versions we not matching.

    Wednesday, April 13, 2016 5:08 PM

All replies

  • Is your Oracle PL/SQL function/package compiling?

    And are you using the latest generated schema in BizTalk ?


    Thanks Arindam

    Wednesday, April 13, 2016 1:12 PM
    Moderator
  • This error is very clearly coming from Oracle.

    So, you need to investigate this on that side.  You may be passing an incorrect parameter, but the problem is not with BizTalk or the WCF Oracle Adapter.

    Wednesday, April 13, 2016 1:22 PM
    Moderator
  • It worked :).

    Oracle Client and Oracle DB versions we not matching.

    Wednesday, April 13, 2016 5:08 PM