Same Database But Strange Error

Topics: Data Access Application Block
Jun 4, 2012 at 8:32 AM

Hi,

We are developing a web application and using Enterprise Library 5.0 for our Data Access Layer in teh application. We also use Oracle.DataAccess.dll (ODP.NET) version 2.112.2.0 to connect to the Oracle database.

We deployed our web application both test and production server. The database versions for the test server is 11.2.0.1 and for the production is 11.2.0.3.

The problem is that when we call a procedure from the test server, it gives ORA-06550,PLS-00306 (wrong type of parameters), but when we call the same procedure it does not give any error.

Web applicaiton is located on IIS 7.0 and we only redirect it to test or production server if needed, so there is a one application. Also, to be sure, we execute the same package again on the test server and we got error again.

Ayn idead for that, it will be very helpful for us.

Thank you.

Jun 6, 2012 at 6:49 AM

Are you using System.Data.OracleClient as the DatabaseProvider?  System.Data.OracleClient is deprecated so you should use ODP.NET.  EntlibContrib has an ODP.NET Provider that you can use.  In terms of your error, if the calling code and client server are the same then it sounds like it could be a configuration issue with the database/database server.  Or perhaps a bug in 11.2.0.1 that was resolved in a later release?

--
Randy Levy
Enterprise Library support engineer
entlib.support@live.com