Solved

problem calling SP with Oracle Oledb in ASP

Posted on 2001-08-31
8
896 Views
Last Modified: 2010-05-18
I am trying to use Oracle Oledb Provider to connect to Oracle 8i DB from ASP using ADO.

I am facing problems while using Oracle Oledb provider for accessing the Stored Procedure with Oracle Native call syntax in ASP.

Up_Get_Prod_Desc_Details stored procedure has five paramater, four input parameter and the fifth Input/Output parameter which is a cursor.

This is the syntax I am  trying to use,

I am creating parameters and appending to the parameter list of command object.

Set strProduct_Id_In = objCmd.CreateParameter("strProduct_Id_In", adVarchar,
adParamInput, 255, "77")
objCmd.Parameters.Append strProduct_Id_In

Set strCountry_Id_In = objCmd.CreateParameter("strCountry_Id_In", adVarchar,
adParamInput, 255, "223")
objCmd.Parameters.Append strCountry_Id_In

Set strLanguage_Id_In = objCmd.CreateParameter("strLanguage_Id_In",
adVarchar, adParamInput, 255, "1012")
objCmd.Parameters.Append strLanguage_Id_In

Set strVersion_id_in = objCmd.CreateParameter("strVersion_id_in", adVarchar,
adParamInput, 255, "107")
objCmd.Parameters.Append strVersion_id_in

objCmd.CommandText = "Up_Get_Prod_Desc_Details '" & strProductId & "','" & strCountryId & "','" & strLangauageId & "','" & strVersionId& "'"
----------------
conection string used is,
strcon = "Provider=OraOLEDB.Oracle;User ID=xxxx;Password=xxxx;Data Source=xxxx;FetchSize=100;CacheType=File;"

----------------
Error: OraOLEDB error '80040e14'

ORA-06550: line 1, column 7: PLS-00801: internal error [22503] ORA-06550: line 1, column 7: PL/SQL: Statement ignored

?
----------------------------
The fifth paramater is a In Out parameter in the SP.
The oracle 8i installation is on Win2k OS.



0
Comment
Question by:vasubr
8 Comments
 

Expert Comment

by:rsaicrag
ID: 6448148
I believe there are still problems using OLE DB Provider Accessing Oracle Database.

Try using Oracle Objects 4 OLE. It is purely for Oracle database. I've tried it and i have no problems accessing Oracle Database..

To give you Information .. please access this site
"http://www.orafaq.org/faqoo4o.htm"
0
 

Expert Comment

by:rsaicrag
ID: 6448177
sorry for the first one..!!

I believe there are still problems using OLE DB Provider Accessing Oracle Database.

Try using Oracle Objects 4 OLE. It is purely for Oracle database. I've tried it and i have no problems
accessing Oracle Database..

To give you Information .. please access this site
"http://www.orafaq.org/faqoo4o.htm

It is also pre-installed in your web server (IIS). Try to look for it.
0
 

Author Comment

by:vasubr
ID: 6449663
Thanks for the answer but it is of no use to me as I have to use the ADO object and there is no escaping it.

If you have come across any usage of ODBC or OLEDB for oracle please do refer it to me.

Thanks again
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:vasubr
ID: 6449705
Thanks for the answer but it is of no use to me as I have to use the ADO object and there is no escaping it.

If you have come across any usage of ODBC or OLEDB for oracle please do refer it to me.

Thanks again
0
 

Expert Comment

by:rsaicrag
ID: 6485055
Well, OO4O is the best Data Access and Data Management you can use to access Oracle Database.

I had the same problem as yours. But i ended using OO4O.

Just in case you found a solution,i would be very delighted! if you could send me the solution. Please rsaicrag@hotmail.com . Thanks in advance.
0
 

Author Comment

by:vasubr
ID: 6485405
We have solved the probelm with many trial and error and upgrades. Though this may not be the perfect solution, here it is for your reference.

We had the 8.1.6 server and the 8.1.6 driver. We updated the oledb driver to 8.1.7.2 and the connection string we have used is as follows,

strcon = "Provider=OraOLEDB.Oracle;User ID=xxxx;Password=xxxx;Data Source=xxxx;chunksize=65000;"

this seems to have solved the problem for now. I do not what it will throw up in the future.

Thanks for your help
vasu



0
 
LVL 33

Expert Comment

by:hongjun
ID: 7402393
This question appears to have been abandoned. Please come back to this question and do the necessary evaluation or feedback. I will invite a Moderator to close this question if there's no reply from you after seven days.

I suggest
<PAQ with no refund>

** PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER **

hongjun
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7429362
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

815 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

13 Experts available now in Live!

Get 1:1 Help Now