Aug 13, 2009 at 7:01 PM
Edited Aug 13, 2009 at 7:03 PM
I am trying to use the Data block to connect to Oracle. I tried the following setting in my app.config:
<add name="TestOraDB" connectionString="Data Source=TestOraDB; User Id=test; Password=test" providerName="Oracle.DataAccess.Client" />
Since I used the ODP.net data provider, the Data block was resolving it to the GenericDatabase type. When I try to insert a row into a table, the binary data is not inserted. It just inserts a null.
Insert Into TableA (VarcharData, BinaryColumn) Values ('SomeData', :BinaryData);
This just inserts 'SomeData' and null for the values. There is no error thrown.
When I run the same statement with System.Data.OracleClient in the ProviderName, it saves the binary data just fine.
Is this to be expected?