ASP calling oracle procedure return error: ORA-06550
Posted on 2006-07-18
I'm new to calling Oracle procedures from ASP and i tryed to call a procedure from Oracle using ASP and ADO.
I tryed to read arround to find solutions but nothing helped me... it's true, i'm begginer with oracle (maybe this dont help me :))
That's why i ask here.
Microsoft OLE DB Provider for Oracle (0x80040E14)
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_TIP_PRODUS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
create or replace procedure sp_Tip_Produs
prcDenTipProd out sys_refcursor,
pnCodRetur in out number,
pcMesajRetur in out varchar2
objCmd.ActiveConnection = objConn
objCmd.CommandType = adCmdStoredProc
objCmd.CommandText = "sp_Tip_Produs"
objCmd.Parameters.Append = objCmd.CreateParameter("CodRetur", adNumeric, adParamOutput)
objCmd.Parameters.Append = objCmd.CreateParameter("MesajRetur", adVarChar, adParamOutput,64,"")
Set objRs = Server.CreateObject("ADODB.RecordSet")
Set objRs = objCmd.Execute
I tryed to made like i read in different tutorials found on internet but i get the same error or other errors.
Maybe i forgot something about declaring parameters. Maybe is someone who already made something like this and he will know what i made wrong and can help me with an answer.