.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Oracle Error on x64 bit

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :.NET Framework
Hello everybody,   I compiled my application as x64 bit and tried to run it on x64 installation of Server 2003. When connecting to Oracle my application has issued the following error: System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)   at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)   at System.Data.OracleClient.OCI.DetermineClientVersion()   --- End of inner exception stack trace ---   at System.Data.OracleClient.OCI.DetermineClientVersion()   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)   at System.Data.ProviderBase.DbConne

View Complete Post

More Related Resource Links

"An error occurred while retrieving data from Oracle Instance..."


I have succeffuly Imported the ADF and have also successfully created a Business Data Column. But when I try to query data , I get the following error

An error occurred while retrieving data from Oracle Instance. Administrator, see the server log for more information

And this is what I found in the Application Logs
A Metadata Exception was constructed in App Domain '/LM/W3SVC/81256521/ROOT-1-129217212004078822'. The full exception text is: LobSystem could not be found using criteria 'id=476'.

Adding Oracle table into SSIS project --Oracle error occurred, but error message could not be retrie

Hi all I am new to design SSIS packages,to day I stated creating package SSIS package and adding the Tables,while adding tables,one of the table giving an below error . I verified the table structure it has one "CLOB" datatype. can some body help how to add this table( whole idea of the package is I have Dump those tables with structure and Data to SQL Server 2008 Database)  =================================== Oracle error occurred, but error message could not be retrieved from Oracle. Data type is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at System.Data.OleDb.OleDbCommand.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType) at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV() Thanks in Advance.   SNIVAS

HOWTO: Verify that custom error handling solutions do not expose padding oracle


I've done some digging and come up with what I think is useful information for you if you have a custom error handling solution in place instead of or as well as the usual ASP.NET <customErrors> stuff.

From comments on ScottGu's post it seem to be that the main suspect to be the actual padding oracle is WebResource.axd (possibly other axd's).

  • If you look in .NET Reflector at the IHttpHandler.ProcessRequest method in  System.Web.Handlers.AssemblyResourceLoader there's a call to Page.DecryptString early on.
  • This is the thing that will cause a HTTP 500 status to be returned if it fails, e.g. if the padding, etc in Request.QueryString["d"] is invalid
  • If the attacker manages to get the padding right, then it continues on, ultimately to call throw new HttpException(404...)

It's this differentiation: is the padding correct (404) or not (500) that is at the root of the exploit: the padding oracle.

If your error handling returns exactly the same response for both - it masks the oracle. To test if you're vulnerable externally, a simple test is to request both:

  • webresource.axd?d=foo
  • webre

Having error in SSRS using oracle query


Hi ,

I have to create report based on date filter but when i used below query ,an error has occured

ORA - 01745 : invalid host/bind variable name.


query is


select top 2* from tablename where prodate>=:date and prodate<:date +1




ORA-06550, PLS-00306; Error inserting data to Oracle procedure.


I have tried to troubleshoot this problem but to no avail. I get error while inserting a big chuck of data to Oracle package containing procedure 'INSCRAPP'. The error message is,

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'INSCRAPP' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

The C# code is big but I am providing the parameters I am passing,


                OracleParameter param_fName_in = new OracleParameter("fName_in", OracleType.VarChar);
                param_fName_in.Value = FirstName;
                param_fName_in.Direction = ParameterDirection.Input;
                OracleParameter param_mi_in = new OracleParameter("mi_in", OracleType.VarChar);
                param_mi_in.Value = MiddleInitial;
                param_mi_in.Direction = ParameterDirection.Input;

                OracleParameter param_lName_in = new OracleParameter("lName_in", OracleType.VarChar);
                param_lName_in.Value = LastName;
                param_lName_in.Direction = ParameterDirection.Input;

                OracleParameter para

Oracle.DataAccess causes 64 bit / 32 bit error in ASP.NET / Visual Studio 2005


This one is driving me nuts.


I have developed some ASP.NET pages using Web Developer Express on a 64 bit (Intel Xeon Quad core) machine. This has gone very well, part of my code access an Oracle database using the Oracle.DataAccess.Client namespace (Oracle 64 bit ODP.NET version All works beautifully.


Just bought the full version of Visual Studio 2005, and now when I try to build my web site, I get an error saying "Attempted to load a 64-bit assembly on a 32-bit platform...". The site won't build.


This makes no sense to me. ASP.NET is configured to run under the 64 bit .NET 2.0 framework. A call to IntPtr.Size on a page confirms that ASP.NET is running in 64 bit mode. So why should VS 2005 tell me I am trying to load a 64 bit assembly on a 32 bit platform???


I have SP1 for VS2005, by the way...


Incredibly frustrating...



Error deploying a Cube using an Oracle Client




I am trying to deploy a cube on a 64 bit machine with SSAS 2008 (32 bit) pointing to an Oracle database using a 32bit Oracle client.


I can create a data source and I can test the database connection without problems.



Oracle Error when Selecting from Gridview that is bound to another Gridview



I've been working on a webform to pull data from an oracle database v10. I can create a gridview1 with Selection enabled and it will populate with data without a problem. However when I create a second gridview and bind with a control to the first gridview, I get the following error at runtime when I click on one of the Selects.

Exception Details: Oracle.DataAccess.Client.OracleException: ORA-00936: missing expression

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OracleException (0x80004005): ORA-00936: missing expression]
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) +1440

Error deploying SSAS 2008 cube connected to oracle client


I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when I try to deploy the cube on my SSAS 2008 server, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).


Errors in the high-level relational engine. A connection could not be made
to the data source with the DataSourceID of '', Name of ''.

Errors in the OLAP storage engine: An error occurred while the dimension,
with the ID of '', Name of '' was being processed. <

oracle dataaccess error




I am getting below error when I pulished my web application on 64 bit is it there any 64 bit oracle client

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.




Error on getting return value from Oracle procedure in SSIS package

In my case, I want to execute a stored procedure in Oracle database using SSIS package and if there has error in Oracle, I want to get the error message from Oracle and pass it to SSIS to log the error.

I can execute the stored procedure through SSIS successfully, but the problem is I cannot get the error message using OUT parameter of procedure in Oracle, the following part is what I have done to test whether SSIS can fulfill my requirement:

1. Oracle client installed, use Microsoft OLE DB Provider for Oracle, Test Connection to Oracle succeeded.

2. The stored procedure created in Oracle database:
    create or replace p1(in1 varchar2, out1 OUT varchar2) as begin
        out1 := 'nice';

3. In the SSIS package, I add a "Execute SQL Task" component:

Variable defined = User::output (String datatype)
ResultSet = Single Row
SQLSourceType = Direct Input
SQLStatement =

        in1 varchar2(10);
        out1 varchar2(10);
        in1 := 'wow';
        out1 := '1a2';

Trying to connect to Microsoft OLEDB Provider for Oracle ...but giving the following error


Hi All,

When I am trying to Connect to Oracle 11g using SSIS OLEDB source adapter ....Its giving me the following error.

TITLE: Connection Manager

Test connection failed because of an error in initializing provider. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Tried various ways by changing the TNSNames file and Sqlnet file...but I am unable to connect to oracle database...

If any body have any ideas...can you share with me ASAP...Appreciate your help.




Error on mapping oracle varchar2 to sql server 2008 using import facility, defaults to type 129 in m



I am trying to use the import wizard to import an oracle 10g table into an sql server 2008 (10.0.2531) database, it comes up with the error 'data types of source columns were not mapped correctly to those available on the destination provider'. When I go into 'edit mappings' it shows all the varchar2 oracle columns mapping to type 129 ? all the other columns have normal mapping types. If i go through and change 129 to varchar the import will work ok.

I understand that in c:\Program files\microsoft sql server\100\dts\mappingfiles there is a series of files that map datatypes to/from different sources, there are 3 files

oracleclienttomssql , oracleclienttomssql10 , oracleclienttossis10 which have a varchar2 to nvarchar mapping

and 2 other files  oracletomssql ,  oracletomssql10 which map varchar2 to varchar and one other file, oracletossis10 which maps varchar2 to dt_str

I running the import on a server with an Oracle client installed with sql server 2008 (10.0.2531).

I am not sure which mapping file is being used ? and whichever one is being used it should provide a mapping rather than type 129 (whatever that is).

I would like to get this mapping resolved as I have many tables to import and over time the structure of the Oracle tables will change so I want to use import as the easiest optio

SQL Oracle Replication Error...Please Help!!!

I had created Oracle Publisher (MP5T) on my server. Configured SQL subscriber. Runs fine.

Then i create SQL Publisher. OK upto here. Then configure Oracle Subscriber. In Datasource/TNS name, i add MP5T.

This is giving me error message

SQL Server could not create a subscription for Subscriber 'MP5T'. (New Subscription Wizard)
Heterogeneous publisher 'MP5T' cannot be defined as a subscriber.
Could not create Subscriber.
The subscription could not be found.
Changed database context to 'OracleTest'. (.Net SqlClient Data Provider)

Please advice me...!

Is there something that we cannot configure same Oracle Publisher and Subscriber on one server??
Or can anyone advice me why i am getting this error message??

Error while oracle to sql migration with SSIS


Hello frnds 

i am getting these errors in the SSIS package which is importing  data from oracle to SQL SERVER.

1)[OLE DB Destination [22]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80004005  Description: "Invalid date format".

2)[OLE DB Destination [22]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Destination Input" (35)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (35)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

3)[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "OLE DB Destination" (22) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (35). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. &n

Oracle Data Provider for .NET error


Hi Members,

I'm trying to invoke an procedure in Oracle with my C# code and it keeps erroring out as "Invalid number or type of argument".

I've passed my statement as query string and try executing it. It worked fine but it keep failing when I call it via a Procedure. I've copied the procedure, source and the error message as well.

Kindly suggest.

Source Code:

using (IMTConnection conn = ConnectionManager.CreateConnection())
                        ((BasePage)this.Page).GeneralInformation = a + "-" + ucAdjustmentSettings.Settings.InvoiceID.GetType() + "-" + b + "-" + ucAdjustmentSettings.Settings.AccountID.GetType() + "Done";
                        string callStatement = "SP_ADJUST_INVOICE";
                        //string qrystr = "SELECT id_view FROM t_prod_view

Error Accessing Oracle Database in a visual web part.


Hello All,

  I'm new to SharePoint development.  I’ve the development box set up with Windows 7 64 bit, share point development environment installed (SharePoint Foundation) with all the hot fixes and I’m able to create and publish a visual webpart and access it. I’ve also installed the 32-bit ODAC (ODAC 11.2 Release 3 ( with Oracle Developer Tools for Visual Studio) and I see the Oracle.DataAccess file in the GAC installed. Here are the results from GAC

C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>gacutil /l Oracle.DataAccess

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend