ASP calling oracle procedure return error: ORA-06550


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.

Error Type:
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

Oracle procedure:
create or replace procedure sp_Tip_Produs
 prcDenTipProd out sys_refcursor,
 pnCodRetur   in out number,
 pcMesajRetur   in out varchar2

Asp code:
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.

Thank you
Who is Participating?
dfu23Connect With a Mentor Commented:
Could be the connection type ... look here:
Anthony PerkinsCommented:
You forgot to create the first parameter prcDenTipProd
horatiumAuthor Commented:
thank you dfu23.
After i made a DSN connection isteand of ADO, is working without any error.
Strange behavior but i found a solution to start testing.

Thank you

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

horatiumAuthor Commented:
i cant give you grade A
you just gave me an intermediat solution :)
Grade A it was if you explain what i have that error with "Provider=MSDAORA.1; Data Source=DBAAA; User ID=***; Password=***"
Just to clarify:

You are still using ADO ... ActiveX Data Object. You have just changed the data connection type which provides the functionality you need.
horatiumAuthor Commented:
yep, i know. I already made it to work. I had ONLY to change the connection string to a DSN connection. I think DSNless is not on Oracle style, or i need to do more things. I have only InstantClient (maybe this is a problem too).
anyway, thx for your help, it's already working and is not a problem to have a DSN connection (we have our own hosting server) :)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.