odp.net
Can an Oracle stored procedure that has a nested table parameter be called from ODP.NET?
I\'ve got a stored procedure that has a couple parameters that are nested tables. CREATE TYPE FOO_ARRAY AS TABLE OF NUMBER;[详细]
2023-02-22 20:12 分类:问答Can I see the actual query generated when using OracleParameters with OracleCommand?
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[详细]
2023-02-20 14:36 分类:问答Need some inputs on Oracle instant client
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.[详细]
2023-02-20 12:51 分类:问答ODP.NET VB.Net calling a stored procedure and returning a refCursor
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[详细]
2023-02-19 22:54 分类:问答Deploy ODP.Net 1.x with Oracle Instant Client?
I have an issue with adjusting my application to use separated Oracle Install Client/ODP.Net configuration.[详细]
2023-02-19 10:01 分类:问答ORA-01400 can't insert null value... but I am NOT inserting null value!
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[详细]
2023-02-17 07:21 分类:问答ORA-01036: illegal variable name/number on PL/SQL script
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[详细]
2023-02-17 03:18 分类:问答OracleBulkCopy AutoCommits
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[详细]
2023-02-16 20:46 分类:问答odp.net freezing on executenonquery while calling oracle storproc with xmltype input parameter
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[详细]
2023-02-15 04:47 分类:问答ASP.NET Oracle ODP.NET Integrated Security Slowness
The following results in successful sub-second page loads. <add name=\"test\" connectionString=\"Data Source=TEST_ORACLE;User Id=user;Password=password;\" />[详细]
2023-02-15 03:30 分类:问答