AresUnlimited
August 22nd, 2001, 04:32 AM
Sorry for my english.
I have such problem
Exist stored procedure, It has two input parametrs
god and nsrt
god - has type varchar2, and nsrt - number
(database Oracle8).
Below cod:
Set cm1 = Server.CreateObject("ADODB.Command")
Set cm1.ActiveConnection = cn
Set param1 =
cm1.CreateParameter("god_",adChar,adParamInput,20,god)
cm1.Parameters.Append param1
Set param2 = cm1.CreateParamete "nsrt_",adNumeric,adParamInput,22,nsrt)
cm1.Parameters.Append param2
cm1.CommandType = adCmdStoredProc
cm1.CommandText = "AresSelectFromEsert1"
Appear message:
ORA-06550: Row 1, column 7: PLS-00306: error type arguments in 'ARESSELECTFROMESERT1' ORA-06550: Row 1, column 7: PL/SQL: Statement ignored .
Please help.
I have such problem
Exist stored procedure, It has two input parametrs
god and nsrt
god - has type varchar2, and nsrt - number
(database Oracle8).
Below cod:
Set cm1 = Server.CreateObject("ADODB.Command")
Set cm1.ActiveConnection = cn
Set param1 =
cm1.CreateParameter("god_",adChar,adParamInput,20,god)
cm1.Parameters.Append param1
Set param2 = cm1.CreateParamete "nsrt_",adNumeric,adParamInput,22,nsrt)
cm1.Parameters.Append param2
cm1.CommandType = adCmdStoredProc
cm1.CommandText = "AresSelectFromEsert1"
Appear message:
ORA-06550: Row 1, column 7: PLS-00306: error type arguments in 'ARESSELECTFROMESERT1' ORA-06550: Row 1, column 7: PL/SQL: Statement ignored .
Please help.