|
-
August 22nd, 2001, 04:32 AM
#1
Stored Procedure
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.
-
August 22nd, 2001, 07:55 AM
#2
Re: Stored Procedure
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|