Click to See Complete Forum and Search --> : Stored Procedure


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.

phunkydude
August 22nd, 2001, 07:55 AM
To Debug I suggest you try and iterate through the command.parameters collection to check if their all there. Also test some of the properties, direction, value, type.
Show us the execute statement as well.