Solved

ASP calling oracle procedure return error: ORA-06550

Posted on 2006-07-18
6
1,290 Views
Last Modified: 2008-01-09

Hello,

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:
------
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
0
Comment
Question by:horatium
  • 3
  • 2
6 Comments
 
LVL 14

Accepted Solution

by:
dfu23 earned 300 total points
Comment Utility
Could be the connection type ... look here:

http://www.orafaq.com/forum/t/47963/0/
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
You forgot to create the first parameter prcDenTipProd
0
 
LVL 1

Author Comment

by:horatium
Comment Utility
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

0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 1

Author Comment

by:horatium
Comment Utility
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=***"
0
 
LVL 14

Expert Comment

by:dfu23
Comment Utility
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.
0
 
LVL 1

Author Comment

by:horatium
Comment Utility
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) :)


0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now