Solved

ASP calling oracle procedure return error: ORA-06550

Posted on 2006-07-18
6
1,296 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Accepted Solution

by:
dfu23 earned 300 total points
ID: 17131598
Could be the connection type ... look here:

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

Expert Comment

by:Anthony Perkins
ID: 17142022
You forgot to create the first parameter prcDenTipProd
0
 
LVL 1

Author Comment

by:horatium
ID: 17144441
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 1

Author Comment

by:horatium
ID: 17144454
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
ID: 17150911
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
ID: 17155650
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Button to go back 3 39
Downside of adding characters set in ASP pages 6 36
ASP AND XML 3 31
JQuery DataTable Functionality 8 21
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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