odp.net
How to use SQL 'IN' (or 'ANY') operator with VARRAY in PL/SQL
My .NET code is currently using ODP.NET to call a stored procedure many times to operate on various rows in many tables.The .NET code has an array of the rows to change.Only one parameter changes in e[详细]
2023-03-20 10:54 分类:问答Check validity of an OracleDependency
I am continuously running a service (coded in c#) on a Windows server, and I am using the OracleDependency object (provided by ODP.NET) to monitor changes affecting s开发者_如何学Pythonome tables in a[详细]
2023-03-18 07:22 分类:问答Does the Oracle ODP use the Oracle Listener?
Im using ODP.net for 11g with no connectivity problems but I turned off the oracle listener and was still able to c开发者_StackOverflow中文版onnect and pull data.[详细]
2023-03-17 12:57 分类:问答Oracle Dependency for Change Notification in .NET Project
I\'m not having any luck getting the change notification back from the DB server.My local firewall is off.We\'re wondering if there are any other environmental/machine settings that would be preventin[详细]
2023-03-17 05:37 分类:问答Oracle error ORA-01722 while updating DECIMAL value
I\'m using ODP to update an Oracle 10g DB with no success updating decimal values. Ex: UPDATE usertable.fiche SET DT_MAJ = \'20110627\',var = 60.4 WHERE NB = \'2143\'[详细]
2023-03-16 03:05 分类:问答How to use EZCONNECT format without sqlnet.ora file for deployment
I have developed a windows forms Application which talks to an Oracle Server. I am using ODP.net and deploying using the bare minimum dlls, as given in the solution to this Question[详细]
2023-03-14 01:37 分类:问答ODP.NET Oracle.DataAccess ArrayBindCount OUT Array parameters exception handling
my scenario: helper = new OracleHelper(); helper.CreateAndOpenConnection(); //cmd = new OracleCommand(\"PCK_JOBS.ARRAY_INSERT\", helper.OracleHelperConnection);[详细]
2023-03-14 00:04 分类:问答Oracle.DataAccess (ODP.NET) Array Binding "Value does not fall within the expected range"
my scenario i\'m using ODP.NET oracle provider with c# 3.5, and i am trying to pass an array as parameter for a procedure...like this:[详细]
2023-03-13 23:15 分类:问答How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
I\'m using a product that provides a database API based on Oracle functions and I\'m able to call functions via ODP.NET in general. However, I can\'t figure out, how to call a function that includes a[详细]
2023-03-13 00:38 分类:问答How to Make ODP.NET 4.0 (64 bit) working on 64 bit machine Windows 7?
I have installed the Oracle Client for the 64 bit machine using the XCopy 11.2 provided by Oracle (Installed everything as per the read me instructions).[详细]
2023-03-11 07:44 分类:问答