Oracle Package Error message issue

Asked By s.sency 160 points N/A Posted on - 06/13/2011

Friends,

I am receiving this package error of MS OLEDB for oracle as unspecified error. I have no knowledge that why this error occurred. All I can say is that, I was just installing an upgrade to the Oracle Form which replaces a few files and during the upgrade I got this error. I thought that this could be because of wrong upgrade package installation. So I downloaded and installed another upgrade package but it also didn’t work out.

The error message is verified and I also couldn’t find it on any of the oracle discussion pages. If anyone of you know how to sort this out or if you have any upgrading package that actually work and don’t give any type of errors, then please let me know as I need it for my work. I have a lot of work pending due to this error.

Thank you!

Package Error

Error Source : Microsoft OLE DB Provider for Oracle

Error Description : Unspecified error

Oracle error occurred, but error message could not be retrieved from Oracle.

Data type is not supported.

• Status: Open
• Question Views: 1332
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Martha_ray 0 points N/A #121659

Oracle Package Error message issue

Hi,

Copy the details you use in the Dev Server over the TNSNAME.ORA. Make sure that your default domain is matched with your Dev Server. Avoid saving sensitive details on your packages. Only use the configuration files to store connections. Be strict on your security and admin settings. Do not use Package creator Password that kills encryption contents. Check if you are deploying packages from machine to machine. If you are using a 64 bit system, fix the project property by debugging Run64bitRuntime to false.

Verify that you can connect to Oracle and can retrieve data using SQL Plus tools. Make sure that all necessary Oracle components are installed on your system. When using Internet Information Server (IIS) computer, check if you are rebooting your system at least once. This refreshes the connection on your computer.

Get back if you will still encounter the problem.

About Martha_ray

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/19/2011
• Question Category: Oracle Database