I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, seemingly randomly, will throw an Oracle exception: Exception: ORA-03113: end-of-file on communica...
I am setting up a test version of my website against a new schema. I am trying to connect using the proxy connection and am getting the following error: ORA-28150: proxy not authorized to connect as client my connect string has the following form: Data Source=Instance; User Id=user; Proxy User Id=prxy_usr;Proxy Password=prxy_p...
Hi all, I'm getting ora-01475 whenever I try to insert a null value in a column (of type DateTime) after some records have already been inserted that have real date values. I'm using the OracleParameter constructor that takes the name and the value as an object (I assume the data type is then implied from the datatype of the object), bu...
I am developing an application with VS208 for different Oracle versions. I am wondering if I need to install different version of ODAC to do this, or does the latest release has backward compatibility? Thanks in advance, ...
I have an application that's using Oracle.DataAccess to connect. I've already discovered that the footprint can be lessened by using ODAC 11 with xcopy deployment. That's already a big win. Ideally, though, we would like to not have to alter any path variables and have all the ODAC files in a subdirectory underneath the application's ...
I want to be able to run my SqlDataProvider against an oracle stored procedure. I can use Microsoft's Oracle Provider but that wouldn't allow me to call a stored procedure. has anyone been able to get this to work? I particularly want to be able to use declarative data binding. I have been able to programatically create a DataTable but I...
I haven't been able to find this explicitly stated anywhere yet, but a bunch of examples I've found online follow what I've been doing. I have a C# class which uses ODP.net to connect to an Oracle DB and run a procedure that's in a package. My package has stored procedures which take a ref cursor output parameter. All the procedure ...
As the code shown below, I want to get value from the OracleParameter object. Its datatype is datetime. ... Dim cmd As New OracleCommand("stored_proc_name", cnObject) cmd.Parameters.Add("tran_date_out", OracleDbType.Date, ParameterDirection.Output) ... cmd.ExecuteNonQuery() ... Dim tranDate As Date tranDate = cmd.Parameters("tran_d...
I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. I am too late in the development process to make a change. Am I heading for trouble? Have you had any experience running 11g client against a 10g server? ...
How can i enable tracing in a odp.net client from the connection string? Just adding the parameters traceFileName, TraceLevel and TraceOption ? ...
I have an app that uses a local version of ODAC 11 below the directory that the .exe file is in. The idea is that we want our app to use the local ODAC 11 regardless of what else the user has installed on her machine. Oracle.DataAccess.dll is in the same directory as the .exe. It works fine when the client machine has no Oracle client...
I'm adding the odp configuration in the application web.config file. For this I have a configuration section named "oracle.dataaccess.client". Therefore I'm adding an entry in the <configSections> section. Something like this: <section name="oracle.dataaccess.client" type="System.Data.Common.DbProviderConfigurationHandler, System.Data,...
Suppose I have some application A with a database. Now I want to add another application B, which should keep track of the database changes of application A. Application B should do some calculations, when data has changed. There is no direct communication between both applications. Both can only see the database. The basic problem is: ...
After quite some time developing with Oracle Client 9.2.0.7, and the ODP.NET to go with it, targeting .NET 1.1, we are upgrading our code line to .NET 3.5 and we are also considering upgrading the Oracle Client version. I wonder if there are any "gotchas" as to whether specific versions should be used/not used? For example Oracle Clien...
My client have an x64 server where he installed both x32 and x64 versions of Oracle Client. After he installed my web application and tried to run it he got "An attempt was made to load the program with an incorrect format (HRESULT 0x8007000B)" exception about Oracle.DataAccess.dll His IIS configured to 64 bit. I event asked him to ad...
I have Oracle9i Release 2 ODAC installed and we are migrating from Microsoft .NET Data Provider for Oracle. We have some SqlCommand caching implemented, that uses System.Data.SqlCommandBuilder.DeriveParameters(result) (var result is type of SqlCommand), but there is no DeriveParameters() method until ODP.NET version 10. Perhaps anyone ...
Are the Oracle ODP.NET libraries redistributable? As in, can I simply include the Oracle.DataAccess.dll with my application & reference it without getting into any legal hot water? The download license for the ODAC on OTN is fairly incomprehesible legalese that doesn't make it clear whether I can or can't include the dll directly. ...
Hi, We are developing a Visual Studio.NET 2008 application with Oracle 9i as backend. Is it true that the usage of Stored procedures would be faster than Inline SQL ? This is a debate with my co-programmers. We are using ODP.NET (Oracle Data Provider for .NET) from Oracle. Thanks. ...
I'd like to pass a set of record identifiers into an Oracle procedure, using a comma-separated string. I want to place this into a temp table and then join off that in further processing. How would I go about this? Better approaches than CSV's would be great to hear about too. I'm using ODP.Net for data access. ...
I am trying to parse a column of strings in Oracle (version 8i) to an integer. I am accessing the results through Oracle.DataAccess library I'm already using TO_NUMBER with a mask to convert the string into a number with no decimal places. The problem is that the value in the client code is being retrieved as a decimal rather than an ...