none
WCF-Adapter Oracle - call a stored procedure

    Allgemeine Diskussion

  • Hello,

    i used Add -- > Add Generated Service --> Consume Adapter Service to execute a stored procedure.

    i set this binding options:

    "enableBizTalkCompatibilityMode" = True

    "useAmbientTransaction" = False

    the rest is default!

     

    when i want to execute it, i get the following error:

    Event Type:    Error
    Event Source:    BizTalk Server 2009
    Event Category:    BizTalk Server 2009
    Event ID:    5754
    Date:        13.01.2011
    Time:        10:37:07
    User:        N/A
    Computer:    AM
    Description:
    A message sent to adapter "WCF-Custom" on send port "WcfSendPort_OracleDBBinding_WEBCADIM_Package_STL_VERWENDUNG_IN_MLFB_Custom" with URI "oracledb://dmart.domain.de:1524/dmart/Dedicated" is suspended.
     Error details: Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at "SYS.OWA_UTIL", line 325
    ORA-06512: at "SYS.HTP", line 1322
    ORA-06512: at "SYS.HTP", line 1397
    ORA-06512: at "SYS.HTP", line 1689
    ORA-06512: at "SYS.HTP", line 71
    ORA-06512: at "WEBCADIM.SITE_PARTS", line 132
    ORA-06512: at "WEBCADIM.STL_VERWENDUNG_IN_MLFB", line 42
    ORA-06512: at line 2 ---> Oracle.DataAccess.Client.OracleException ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at "SYS.OWA_UTIL", line 325
    ORA-06512: at "SYS.HTP", line 1322
    ORA-06512: at "SYS.HTP", line 1397
    ORA-06512: at "SYS.HTP", line 1689
    ORA-06512: at "SYS.HTP", line 71
    ORA-06512: at "WEBCADIM.SITE_PARTS", line 132
    ORA-06512: at "WEBCADIM.STL_VERWENDUNG_IN_MLFB", line 42
    ORA-06512: at line 2    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
       at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
       at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper)
       --- End of inner exception stack trace ---

    Server stack trace:
       at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

    Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result)
     MessageId:  {53D1D76A-883B-475A-B3FB-A4A0AD58DCC5}
     InstanceID: {8D271AA0-A97F-4834-BC42-C2D6D91F7BAC}

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


    the 2 parameter for the SP are varcar2 and correct.

    i wonder when i saw that the response schema is emtpy... is this normal?

    can anyone help me please?

    • Typ geändert Andrei Talmaciu Mittwoch, 2. Februar 2011 15:15 inaktiver Thread
    Donnerstag, 13. Januar 2011 10:02

Alle Antworten

  • Hello,

    is the Stored Procedure working correctly with the arguments it gets?
    Have a look here: http://www.orafaq.com/wiki/ORA-06502
    I hope this helps...

    Have a nice day,
    Martin

    Samstag, 22. Januar 2011 15:07
  • Hi du :)

     

    die Fehlermeldung deutet auf einen PLSQL Fehler hin. Ich denke, es liegt nicht am BizTalk Server oder deinem Aufruf, sondern an der SP.

    ORA-06512: at "WEBCADIM.SITE_PARTS", line 132
    ORA-06512: at "WEBCADIM.STL_VERWENDUNG_IN_MLFB", line 42

     

    Ich würde in der Gegend mal schauen, ob da was ist.


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://pi.hauth.me

    Samstag, 22. Januar 2011 16:15