I\'ve got a stored procedure that has a couple parameters that are nested tables. CREATE TYPE FOO_ARRAY AS TABLE OF NUMBER;
I want to use ODP.NET to run various queries on an oracle database and I\'d like to use parameters in the query. Here\'s a trivial example snippet (omitting all the obvious setup bits of the OracleCon
Currently i am using ODP.Net.Is Oracle Instant client something to replace this or an addon. Some sites talked about using this for both 64bit and 32 bit machines.
This problem has driven me mad for over a day now. I can create a connection to the database, I can execute sql and return results from that but I can\'t seem to call a stored Procedure. Here is the c
I have an issue with adjusting my application to use separated Oracle Install Client/ODP.Net configuration.
I am开发者_如何学运维 trying to insert data in an Oracle table by using ODP.NET from a C# application, but I am getting an ORA-01400 can\'t insert null value error for a column in which I am NOT inser
I\'m fairly new to the PL/SQL game and I\'m attempting to come up with a short script to create logins and grant read-only/read-write privs (making the necessary grants as necessary). However, I am en
C#.Net I am using OracleBulkCopy to copy data to global temp tables that are declared as Delete on commit. So when I use OracleBulkCopy.WriteToServer(Da开发者_StackOverflow社区taReader). It commits an
I have an issue in calling oracle stored procedures(oracle xmltype as input parameter) in ASP.NET 2.0 using ODP.NET (Oracle.DataAccess assembly version 9.2.0.700).the web page freezes during processin
The following results in successful sub-second page loads. <add name=\"test\" connectionString=\"Data Source=TEST_ORACLE;User Id=user;Password=password;\" />