• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 939
  • Last Modified:

problem calling SP with Oracle Oledb in ASP

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
vasubr
Asked:
vasubr
1 Solution
 
rsaicragCommented:
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
 
rsaicragCommented:
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
 
vasubrAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
vasubrAuthor Commented:
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
 
rsaicragCommented:
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
 
vasubrAuthor Commented:
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
 
hongjunCommented:
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
 
NetminderCommented:
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now