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'm using Oracle's ODP.Net to manipulate records. When using the XML methods to insert and update records, I've run into a few problems. When I am inserting a new record, I'd like the value of one of the columns to come from a sequence (MySeq.nextval). I'd also like an UPDATE_DATE column to reflect sysdate. I've only seen examples of...
How to generate custom classes with ODP .Net 11g ...
Hi, I used the php script in http://sourceforge.net/projects/dmoz2mysql/files/ to download , extract , clean , parse and insert dmoz data into mysql table. i encounter no problem while processing structure.rdf . But while parsing content.rdf , there is an abrupt pause after inserting 3200000 rows.. and nothing happens after that - ...
I'm trying to build a test environment to test an app against oracle and sql server. The aim is to have the same code base for both test scenarios, the only difference should are some SQL/DDL/... statements that are stored in script files. The problem is that oracle's ODP does not support the execution of scripts but only single commands...
Trying to insert a large audio file into an Oracle 10g database and keep getting this error: ORA-01460: unimplemented or unreasonable conversion requested The byte array length of the audio file is 2702577. The procedure works with smaller array lengths, but not the larger ones. Here is my code and Thanks! Dim oracleConnection A...
Hello, I have .NET 3.5 application wrote in C# using NHibernate. Before I has OracleClientDriver in connection.driver_class property, that say that I use System.Data.Oracle and all works fine, but for some reasons now I need using ODP, so I changed this property to: NHibernate.Driver.OracleDataClientDriver. When I run my code I get follo...
Hi, In Visual Studio running on an XP 64 bit everything runs fine. I have the web.config with an entry: ( to look for the 'bin' folder of the project where two .DLLs are (Oracle.DataAccess.dll, System.Data.OracleClient.dll) But, in the Production environment (Windows 2003, 32 bit), I get an error t...
I am brand new to NHibernate and Fluent NHibernate and I am trying to get the following confguration to work. private static ISessionFactory CreateSessionFactory() { return Fluently.Configure() .Database( OracleDataClientConfiguration.Oracle10.ConnectionString("Data Source=mysource;User ID=myid;Password=mypwd;") ...
I'm currently trying to connect to an Oracle database. I can connect fine on my development machine, but when I deploy to my Win2k3 sp2 server I get the following error. Faile to open connection... Oracle.DataAccess.Client.OracleException ORA-12541: TNS:no liestener at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 err...