Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 933
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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