Devart Forums

my os is winxp simple chinese and delphi 2007 and direct=True
oracle version:10.2.0.3 chartset ZHGBK16
where a table's varchar2 fields more than 2,
when update it show errors!

and the errors is strange: sometimes is ora-01438
sometimes is ora-00001
sometimes is update failed,found 0 records!
sometimes is ora-01010
sometines is NET:unknow error 1

I use ODAC 6.5.0.36.
and when use ODAC 6.25 ,everything works ok!

Please check if an error occurs when Direct = False.

Please specify when an error occurs: on opening a dataset or on editing a record.

when direct=False: work fine;

direct=True: when edit a record it show errors!

We could not reproduce the problem. Please provide a script to create the table (and to insert data if it is necessary to reproduce the problem). Also provide a code that changes the field value so that an error occurs.
Specify the values of the UseUnicode and Charset options of TOraSession.

when I set charset='ZHS16GBK'
it worked.
and if I set pooling=True. it show errors!


but in odac 6.25 . it don't need set charset value! and pooling=True also
worked

In one of the last ODAC build we have changed the default value of the Charset option for compatibility with the OCI mode. Now if you don't set the Charset option, ODAC uses Windows default character set on the client computer.

Please specify what is your Windows character set:
Open Regional and Language options on the Control Panel and select Advanced tab. Specify what language is selected as language for non-Unicode programs.

Open Regional and Language options on the Control Panel and select Advanced tab. Specify what language is selected as language for non-Unicode programs.

It is chinese(china)

We have fixed this problem. The fix will be included in the next build of ODAC.

In odac 6.50.0.37 . The problem is still there!

Sorry, but the fix is not included in the latest ODAC build. We are planning to include it in the next build.

in odac 6.50.0.39 ,The problem is still there!
but only show "update error, found 0 records"

Do you receive the same error if you set the Charset property to ZHS16GBK ?

when i set ZHS16GBK.
it works fine!

We are working on the problem. You will be notified when we fix it.