varchar2 fields numbers can't more than 2!

xalion · Post by **xalion** » Tue 05 Aug 2008 07:51

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

xalion · Post by **xalion** » Thu 07 Aug 2008 02:33

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

Plash · Post by **Plash** » Thu 07 Aug 2008 10:22

Please check if an error occurs when Direct = False.

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

xalion · Post by **xalion** » Thu 07 Aug 2008 15:02

when direct=False: work fine;

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

Plash · Post by **Plash** » Fri 08 Aug 2008 08:53

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.

xalion · Post by **xalion** » Sat 09 Aug 2008 06:02

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

Plash · Post by **Plash** » Mon 11 Aug 2008 09:21

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.

xalion · Post by **xalion** » Mon 11 Aug 2008 10:10

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)

Plash · Post by **Plash** » Thu 14 Aug 2008 10:44

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

xalion · Post by **xalion** » Sat 23 Aug 2008 03:50

In odac 6.50.0.37 . The problem is still there!

Plash · Post by **Plash** » Tue 26 Aug 2008 11:04

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

xalion · Post by **xalion** » Mon 06 Oct 2008 06:13

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

Plash · Post by **Plash** » Mon 06 Oct 2008 09:37

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

xalion · Post by **xalion** » Tue 07 Oct 2008 00:40

when i set ZHS16GBK.
it works fine!

Plash · Post by **Plash** » Wed 15 Oct 2008 07:41

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