I am working in an environment where we get production issues from time to time related to Oracle connections. We use ODP.NET from ASP.NET applications, and we suspect the firewall closes connections that have been in the connection pool too long. Sometimes we get an "ORA-12571: TNS packet writer failure" error, and sometimes we get "O...
Where can I find the listing of ODP to CLR type mapping? On Oracle database, the NUMBER(9,0) type comes out in .NET app as System.Decimal from the MS Oracle driver, but as System.Int32 from ODP driver. I need an exact specification of types coming out from database (not the CLR to DB parameter mapping). ...
Does anybody have any experience going from ODP.net to devArt's dotConnect for Oracle? Some initial testing is showing Direct Connect in 64bit dotConnect running 30% slower at times than our original ODP.net/OCI 32 bit solution. Trying to determine if that's normal or if something may be wrong in my testing approach. Thanks! ...
Converting from usind Micorsofts Syste.Data.OracleClient to what I believe is called Oracles ODT (Oracle.DataAccess 10.2.0.100). When I try and send a date I get this error "ORA-1858: a non-numeric character was found where a numeric was expected". This code worked great using System.Data.OracleClient. cmd.Parameters.Add(New OraclePar...
Hello, I am upgrading a project from EntLib 4.1 to EntLib 5. I've skimmed through the Migration Guide, changed all the references and updated all the config files to point to EntLib 5. All worked fine accept Oracle database access. With the config file: <configuration> <configSections> <section name="dataConfiguration" type="Micro...
My Oracle database returns the error: ORA-12899 - Value too large for column TIT.ESTADO_CIVIL (actual: 2, maximum: 1) But I'm very sure that the sended value is an unique char 'C'. Anyone knows why this is happening? (I'm using C# with ODP.NET) ...
When I try to execute a create procedure using ODP.NET I get back ORA-24344: success with compilation error. However, when I run the same statement in SQL Developer it compiles successfully. Does anyone know what I need to change to get my procedure to compile? Is it a character set issue? I am using Oracle 10g Express, .NET 3.5 SP 1...
Sup guys, heres my view: CREATE OR REPLACE VIEW SISTEMA.VWTELA AS SELECT TEL_DLTELA AS Tela, TEL_DLDESCRICAO As Descricao, TEL_DLTABELA As Tabela, CASE WHEN to_char(TEL_STATIVO) = to_char(1) THEN to_char('Yes') ELSE to_char('No') END as Ativo, TEL_IDTELA AS IDTEL FROM SISTEMA.TEL_TELA; When i do a SELECT * FROM SISTEMA.VW...
I have a window form application running in client machine. some clients are still using oracle92 client and didn't install opd.net in their machine. I have updated my oracle client as 10g, and my application is currently depending on odp.net 10.1. when i deploy this application, it is not working on client's machine since they are still...
My .NET application tries to connect to an Oracle database, but the connection fails to open because it cannot find "OraOps9.dll". xxx.CreatedbConnection() failed to open connection. System.DllNotFoundException: Unable to load DLL (OraOps9.dll). at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel) at Oracle.DataA...
We are facing problem in checking output parameters for “DBNull”. “DBNull” value returned by Oracle stored procedure or function is treated as “null” string by oracle 11g client/ODP.Net provider. This works fine with oracle 10g client as it returns “DBNull”. Because of this all our “DBNull” check fails ...
I have a table with a primary key consisting of two columns. I want to retrieve a set of rows based on two input arrays, each corresponding to one primary key column. select pkt1.id, pkt1.id2, ... from PrimaryKeyTable pkt1, table(:1) t1, table(:2) t2 where pkt1.id = t1.column_value and pkt1.id2 = t2.column_value I then bind the values...
I am using the Oracle Data Provider. I am having trouble calling a function that returns a record type defined as TABLE_NAME%ROWTYPE. How do you do this from C# ...
I am currently developing on a Win7-32bits computer. Everything works fine. It's a ASP.NET application. I was able to use Microsoft's Oracle deprecated .NET provider to connect to Oracle (using 32 bit instant client) and also ODP.NET. No problems at all. Application runs fine. The problem comes when I deploy it to IIS7 on Windows 2008 ...
Hello, I have C# application that retrieve data from AQ with some oracle stored procedure, that stored in package. The scheme is: C# code -> Stored Procedure in Package -> AQ Inside of this stored procedure I use DBMS_AQ for dequeue the data to some object of some type. Now I have this object. My question is how I return it? Previously ...
Is there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects? I know that I can query USER_SOURCE to get the whole procedure but I'd then have to parse the whole procedure, and if the parameter is of type [table].[column]%TYPE I'd then have to query the table schema as well. Either using just sql o...
TYPE point IS RECORD ( X NUMBER, -- The X co-ordinate of the point Y NUMBER -- The Y co-ordingate of the point ); This is defined in my package header. It is then used in a procedure defined in the same package. Is it possible for me to call the procedure via ODP.net? ...
We are getting the following warning from Code Analysis in Visual Studio 2010 and I'm wondering if this is a false positive that we can safely ignore or the code should be refactored to correctly dispose the object. The relevant code: public void MyFunction() { OracleConnection oraConnection = null; OracleCommand oraCommand = n...
Is it possible to correctly pass an OracleParameter to a boolean parameter in a pl/sql stored procedure? ...
I need to retrieve data from an oracle table using a pl/sql stored procedure and odp.net. What is the standard way of doing this? ...