Fragensteller
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,
MartinSamstag, 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 42Ich 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 - OliverSamstag, 22. Januar 2011 16:15