Solved

problem calling SP with Oracle Oledb in ASP

Posted on 2001-08-31
8
892 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

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.

Join & Write a Comment

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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 demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

17 Experts available now in Live!

Get 1:1 Help Now