Recently I have upgraded to dotConnect for Oracle version 8.4.313.0.
The problem that I am facing with upgraded version is, I am not able to execute a Stored Procedure which was working fine with the previous version(dotconnect for oracle 6.30.165.0).
I am getting the below error....while calling this procedure......
{"ORA-06550: line 2, column 3:\nPLS-00306: wrong number or types of arguments in call to 'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2, column 3:\nPLS-00306: wrong
number or types of arguments in call to 'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2, column 3:\nPLS-00306: wrong number or types of arguments in call to
'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2, column 3:\nPLS-00306: wrong number or types of arguments in call to 'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2,
column 3:\nPLS-00306: wrong number or types of arguments in call to 'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2, column 3:\nPLS-00306: wrong number or types of
arguments in call to 'GPY_PR_GETTRANSACTIONDETALS'\nORA-06550: line 2, column 3:\nPL/SQL: Statement ignored"}
Stack Trace:
Code: Select all
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.DataProvider.a(c1 A_0, Object[] A_1)
at Devart.Data.Linq.DataProvider.c(Expression A_0)
at Devart.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)
at PayoneContext.PayoneDataContext.GPY_PR_GETTRANSACTIONDETALS(Nullable`1 IDFILTER_IN, String FROMDATE_IN, String TODATE_IN, String DATERANGE_IN, Nullable`1
AUT_AMOUNT_FROM_IN, Nullable`1 MOV_AMOUNT_FROM_IN, Nullable`1 AUT_AMOUNT_TO_IN, Nullable`1 MOV_AMOUNT_TO_IN, String TRANSACTIONTYPE_IN, String UICCODE_IN, Nullable`1
BANKTRXID_IN, Nullable`1 APPROVEDTRANSACTION_IN, String SHOPTRXID_IN, String ERRORCODE_IN, String AUTHORIZATIONCODE_IN, Nullable`1 PAYMENTMETHOD_IN, Nullable`1
ALERT_IN, String TRANSACTIONSTATE_IN, String THREEDLEVEL_IN, String RED_FRAUDRESPONSE_IN, Nullable`1 IDSHOP_IN, Nullable`1 IDLANGUAGE_IN, String CUSTOMFIELDSID_IN,
String CUSTOMFIELDSVALUE_IN, String GETRESULTSFOR_IN, Nullable`1 ROWNUMFROM_IN, Nullable`1 ROWNUMTO_IN, String SORTBY_IN, String SORTDIR_IN, String ROWFILTERDATE_IN,
String& OUT_ERRORCODE, String& OUT_ERRORMESSAGE) in D:\TEMP\DevartV8\PayoneDataContext.Designer.cs:line 93
This is my procedure without body......
Code: Select all
procedure GPY_PR_GETTRANSACTIONDETALS(IDFILTER_IN IN NUMBER,
FROMDATE_IN IN VARCHAR2 DEFAULT null,
TODATE_IN IN VARCHAR DEFAULT null,
DATERANGE_IN IN VARCHAR DEFAULT null,
AUT_AMOUNT_FROM_IN IN NUMBER,
MOV_AMOUNT_FROM_IN IN NUMBER,
AUT_AMOUNT_TO_IN IN NUMBER,
MOV_AMOUNT_TO_IN IN NUMBER,
TRANSACTIONTYPE_IN IN VARCHAR2,
UICCODE_IN IN VARCHAR2,
BANKTRXID_IN IN NUMBER,
APPROVEDTRANSACTION_IN IN NUMBER,
SHOPTRXID_IN IN VARCHAR2,
ERRORCODE_IN IN VARCHAR2,
AUTHORIZATIONCODE_IN IN VARCHAR2,
PAYMENTMETHOD_IN IN NUMBER,
ALERT_IN IN NUMBER,
TRANSACTIONSTATE_IN VARCHAR2,
THREEDLEVEL_IN VARCHAR2,
RED_FRAUDRESPONSE_IN VARCHAR2,
IDSHOP_IN NUMBER,
IDLANGUAGE_IN NUMBER,
CUSTOMFIELDSID_IN VARCHAR2,
CUSTOMFIELDSVALUE_IN VARCHAR2,
GETRESULTSFOR_IN VARCHAR2,
ROWNUMFROM_IN NUMBER,
ROWNUMTO_IN NUMBER,
SORTBY_IN VARCHAR2 DEFAULT 'trx.DataAut',
SORTDIR_IN VARCHAR2 DEFAULT 'DESC',
ROWFILTERDATE_IN varchar2 default '',
RESULTSET_OUT OUT SYS_REFCURSOR,
out_errorcode OUT VARCHAR2,
out_errormessage OUT VARCHAR2,
ADDITIONALFIELDS OUT SYS_REFCURSOR,
SUMMARY_OUT OUT SYS_REFCURSOR);
.NET 4.0
Asp.Net MVC3
dotConnect for Oracle Trial Edition (Version: 8.4.313.0)
Windows Server 2012
IIS 8.5
Oracle 11g
Could you please explain the cause for this issue?