ASP with Oracle Stored Function Error

Hello,

Oracle 7.3.4 NT

i am trying to call a oracle stored with the following ASP (active server page) code. However it always returns an error when i pass parameters.

Set objRec = Server.CreateObject("ADODB.Command") Set objRec.ActiveConnection = Session("classic_conn") objRec.CommandText = "testa"
objRec.CommandType = 4

objRec.Parameters.Append(objRec.CreateParameter("i_char",adVarchar, adParamInput,20,"10"))
objRec.Parameters.Append(objRec.CreateParameter("v_error_cd",adVarchar, adParamReturnValue, 20))
ObjRec.Execute
' Display the returned argument
response.write "I Char= " & objRec.Parameters("i_char") response.write "Error Code= " & objRec.Parameters("v_error_cd") Set objRec.ActiveConnection = Nothing

the criteria for the TESTA function is:

Function TESTA (i_char IN VARCHAR2) Return VARCHAR2;

All i receive is the following error:

Microsoft OLE DB Provider for Oracle error '80040e14'

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TESTA' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

/classic/search_information.asp, line 35

When i look at the SQL text in Oracle it has the following: begin :V001 := testa(:V002); end;

What are the bind variables :v001 and :v002. Are these not set or is there a way to check the values before the execute command?

Any help would be appreciated.

Thanks, Jim Received on Wed Jun 02 1999 - 16:58:24 CDT