ORA-01461 , ERROR USING MICROSOFT provided system.data.oracleclient in .net 1.1

P

Peruris

Hi Group,
I have a table which contains a CLOB column and 2 varchar2 columns of size
2500, 1500.

Database version oracle 9.2.0.1 and oracle client same version on machine
windows server 2003, enterprise edition,
I have program written in vb.net , using oracle command builder to update
the table , getting the following error
oracle database is a utf8 database., NLS_LANG registry key on the client is
set to AMERICAN_AMERICA.AL32UTF8

ORA-01461: can bind a LONG value only for insert into a LONG column

But when I tried the same code compiled with .net 1.0 , downloaded
system.data.oracleclient 1.0 and executed from .net 1.0 windows advanced
server 2000, oracle client 9.2.01. works fine.

Is there a problem with .net 1.1 provided system.data.oracleclient
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle error when i use System.Data.OracleClient 1.0.5000.0 3
ORA 3114 Error with MS .Net provider for oracle 2
ORA-01461 Error 4
Assembly System.Data.OracleClient not found, from framework 1.1? 1
Oracle 10g and OracleClient .Net 1.0/1.1 6
ORA-01036 Error with Microsoft Provider for Oracle 3
ORA-01461 while moving data from sqlserver to oracle 3
ORA-03113 error when updating an oracle clob column via a view 0

Top