Solved

problem calling SP with Oracle Oledb in ASP

Posted on 2001-08-31
8
899 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
[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
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
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!

 

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

739 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