# Can't update table data in Database Explorer **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [December 10, 2013, 9:48am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963 "2013-12-10T09:48:20Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 10, 2013, 9:48am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/1 "2013-12-10T09:48:20Z")
When I try to update certain tables in Database Explorer, I get the following error: ORA-12899: value too large for column “SCHEMA”.“TABLE\_NAME”.“COLUMN\_NAME” (actual: 2, maximum: 1) The column indicated in the error isn’t even the column I am updating. This doesn’t occur on every table, and I can’t see anything in similarities in the tables it does occur on. This is an urgent issue as several of our data processing team members cannot update data as necessary. Any input would be appreciated. ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [December 10, 2013, 2:00pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/2 "2013-12-10T14:00:36Z")
What is the column’s type? What is the value in that column? ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 11, 2013, 8:51am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/3 "2013-12-11T08:51:10Z")
Aleksey, The column is a CHAR(1) and the current value is 'Y'. In this scenario, if we attempt to update any other field in this table we get this error. In all cases, we are making no changes to the field we are getting the error for. Thanks, Jon King On Tue, Dec 10, 2013 at 2:01 PM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43026.aspx#43026)** > Reply by Aleksey Bazhenov > What is the column's type? What is the value in that column? > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43026.aspx?AbuseContentId=3540bc9d-078f-4580-93a4-6829e450019e&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [December 11, 2013, 10:33am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/4 "2013-12-11T10:33:15Z")
Hi Jon, Unfortunately I cannot reproduce the issue. I created a table and edited values in Sql Editor and in Object Explorer. I attached a script to create the table and populate it. I did not see any issue with editing the column\_3. The only case when I get the same error as you is when I explicitly added a space to the Column\_2. Could you please create the table and try to reproduce the error by editing this table? Thanks Aleksey [Test.sql](https://global.discourse-cdn.com/quest/original/2X/a/a1731cf071f729efc9986e0978bb195ddc4ba2cc.sql) (665 Bytes) ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 11, 2013, 2:39pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/5 "2013-12-11T14:39:12Z")
Aleksey, I was able to resolve this by completely removing all traces of DataPoint and reinstalling. Jon On Wed, Dec 11, 2013 at 10:33 AM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43043.aspx#43043)** > Reply by Aleksey Bazhenov > Hi Jon, > Unfortunately I cannot reproduce the issue. > I created a table and edited values in Sql Editor and in Object Explorer. I attached a script to create the table and populate it. I did not see any issue with editing the column\_3. > The only case when I get the same error as you is when I explicitly added a space to the Column\_2. > Could you please create the table and try to reproduce the error by editing this table? > Thanks > Aleksey > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43043.aspx?AbuseContentId=4a195f61-ec76-4a9d-bf6e-afc5f8096cc7&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 17, 2013, 8:33am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/6 "2013-12-17T08:33:12Z")
Aleksey, This problem has resurfaced. It does not happen on every table, so trying to reproduce it by following your steps in your previous post and hoping it happens is pointless. This only occurs on version 3.4, so it is clearly a regression in Data Point. I would just install a previous version, but this user is on Windows 8.1 and versions prior to 3.4 do not work. Data Point is somehow adding an additional character to the field before sending it to oracle to update causing this problem. If necessary, I can send you a screenshot of the ddl for the table, the data I am trying to update and the error screen. Let me know what is the next step, this is occurring on a key employees workstation making it very hard to complete her duties. Please advise. Jon ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [December 17, 2013, 11:26am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/7 "2013-12-17T11:26:27Z")
Hi Jon, Could you please send the table DDL and tell us what Oracle client you use? In the meantime you could try the following Open Define Custom Statement to Edit dialog ![img_1.png](https://global.discourse-cdn.com/quest/original/2X/e/e4fe72a7d011073d127b33c6b7d3f0c7ce3c6c0b.png) and exclude the column from the list of updatable columns. ![img_2.png](https://global.discourse-cdn.com/quest/original/2X/b/b31df61bbc1220a0ca2766e787033d056340c84e.png) ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 17, 2013, 12:30pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/8 "2013-12-17T12:30:05Z")
Aleksey, Attached is the DDL for the table. The column that seems to be causing the problem in this table is the HPSI\_SALES\_REP column. The problem is not limited to this table, but in each instance, the column is a char(1). We are using the same Oracle client across all of our installations, and it is the 11g R2 (32-bit). I made the change to the updatable columns as you suggested and it resolves the issue for that table, but obviously prevents updating that column if needed. Thanks for your quick response to this issue. Jon On Tue, Dec 17, 2013 at 11:26 AM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43174.aspx#43174)** > Reply by Aleksey Bazhenov > Hi Jon, > Could you please send the table DDL and tell us what Oracle client you use? > In the meantime you could try the following > Open Define Custom Statement to Edit dialog > > and exclude the column from the list of updatable columns. > > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43174.aspx?AbuseContentId=d7522edd-0a15-4f10-a8a9-3def58f75fc5&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [December 17, 2013, 2:19pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/9 "2013-12-17T14:19:49Z")
Hi Jon, Unfortunately I was not able to reproduce it. We’ll continue looking at the issue but before we spend more time I’d like to ask couple questions 1. Could you please verify that you use 32 bit Oracle client? We introduce 64 bit support in TDP 3.4 so it could cause the issue. To do it right click on the Oracle connection and select Property. What is the name of Oracle’s Current home? 2. Do you have other triggers on the table or only SALES\_REP\_IN\_PRUDENT\_BUYER\_TRG 3. Could you execute the following update statement from the SQL Editor? You will have to provide values for all bind variables. UPDATE ORA\_USER.SALES\_REP SET SALES\_REP\_ID = :f1, NAME = :f2, MES\_FLAG = :f3, HPSI\_SALES\_REP = :f4, RVP = :f5, PHONE = :f6, EMAIL = :f7, START\_DATE = :f8, HAS\_COMMISSION\_BASE = :f9, IN\_PRUDENT\_BUYER = :f10 WHERE SALES\_REP\_ID = :f11 1. How critical is the ability to update the column from the grid? 2. Would it be possible to install additional program on your PC to trace the issue? Will you have time to do it? Aleksey ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [December 17, 2013, 2:46pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/10 "2013-12-17T14:46:06Z")
Aleksey, In response to your questions: - Could you please verify that you use 32 bit Oracle client? We introduce 64 bit support in TDP 3.4 so it could cause the issue. To do it right click on the Oracle connection and select Property. What is the name of Oracle’s Current home? It is the 32 bit client, I installed it myself. the path is C:\Oracle\Product\11.2.0\client\_1 and the Home name is OraClient11g\_Home1 - Do you have other triggers on the table or only SALES\_REP\_IN\_PRUDENT\_BUYER\_TRG? No, that is the only one. (Recall that this works on every machine without TDP 3.4, so it is not Oracle related, this table has existed in it's current form for 10+ years) - Could you execute the following update statement from the SQL Editor? You will have to provide values for all bind variables. Updating tables from the sql editor works perfectly UPDATE ORA\_USER.SALES\_REP SET SALES\_REP\_ID = :f1, NAME = :f2, MES\_FLAG = :f3, HPSI\_SALES\_REP = :f4, RVP = :f5, PHONE = :f6, EMAIL = :f7, START\_DATE = :f8, HAS\_COMMISSION\_BASE = :f9, IN\_PRUDENT\_BUYER = :f10 WHERE SALES\_REP\_ID = :f11 - How critical is the ability to update the column from the grid? This is very critical, the user with this issue updates table data in several tables daily and we don't want to create DML for every update she needs to make, this is a small table with only a few fields, other tables with this issue are much larger and would require creation of multiple update statements. The Data Processing team in general prefers to use the grids because it is easier to filter down to the records you want to update and then update dynamically and then update as necessary - Would it be possible to install additional program on your PC to trace the issue? Will you have time to do it? Thanks, Jon On Tue, Dec 17, 2013 at 2:20 PM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43185.aspx#43185)** > Reply by Aleksey Bazhenov > Hi Jon, > Unfortunately I was not able to reproduce it. We’ll continue looking at the issue but before we spend more time I’d like to ask couple questions > 1. Could you please verify that you use 32 bit Oracle client? We introduce 64 bit support in TDP 3.4 so it could cause the issue. To do it right click on the Oracle connection and select Property. What is the name of Oracle’s Current home? > 2. Do you have other triggers on the table or only SALES\_REP\_IN\_PRUDENT\_BUYER\_TRG > 3. Could you execute the following update statement from the SQL Editor? You will have to provide values for all bind variables. > UPDATE ORA\_USER.SALES\_REP > SET SALES\_REP\_ID = :f1, NAME = :f2, MES\_FLAG = :f3, HPSI\_SALES\_REP = :f4, RVP = :f5, PHONE = :f6, EMAIL = :f7, START\_DATE = :f8, HAS\_COMMISSION\_BASE = :f9, IN\_PRUDENT\_BUYER = :f10 > WHERE SALES\_REP\_ID = :f11 > 1. How critical is the ability to update the column from the grid? > 2. Would it be possible to install additional program on your PC to trace the issue? Will you have time to do it? > Aleksey > > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43185.aspx?AbuseContentId=9ceddeb2-52c6-4392-8b52-aeda460885f3&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [December 18, 2013, 9:09am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/11 "2013-12-18T09:09:56Z")
Thank Jon for response. Let’s install Toad for Oracle Trial to trace the update statement that causes the issue. Please download Toad for Oracle from this link [http://www.quest.com/toad-for-oracle/software-downloads.aspx](http://www.quest.com/toad-for-oracle/software-downloads.aspx) . Select the second row as Application Development. After you downloaded and installed the Toad for Oracle run it. Now launch TDP, connect to Oracle, go to Data grid for a table that causes error, and include the column in the list of the Updatable columns. Switch back to Toad for Oracle and go to Database| Monitor | SQL Tracker. In the opened form select TDP and start monitoring by pressing the Start Monitoring button or using Process| Start Monitoring menu item. Now we will get all SQL statements that TDP sends to Oracle. Switch back to TDP and try to reproduce the error. At the same time you should get in Monitoring window something similar to the following screenshot ![6406.Capture.png](https://global.discourse-cdn.com/quest/original/2X/b/b32b817c313cfa6cba03ad9e60f4cb6ce3540d0f.png) Could you post the screenshot with the statement that causes the error? Thanks Aleksey ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [January 17, 2014, 11:01am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/12 "2014-01-17T11:01:00Z")
Aleksey, We are still having this issue, I thought it was related to the columns being defined using byte rather than char, but I have since changed all of the problematic tables to use char and I am still getting the errors. Attached is a screenshot of sqltracker. If I copy the query from sql tracker and run it, it runs fine in sql editor, and if I edit the table using Toad for Oracle rather than Toad Data Point it also works. Jon On Wed, Dec 18, 2013 at 9:10 AM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43196.aspx#43196)** > Reply by Aleksey Bazhenov > Thank Jon for response. > Let’s install Toad for Oracle Trial to trace the update statement that causes the issue. > Please download Toad for Oracle from this link [http://www.quest.com/toad-for-oracle/software-downloads.aspx](http://www.quest.com/toad-for-oracle/software-downloads.aspx) . Select the second row as Application Development. > After you downloaded and installed the Toad for Oracle run it. > Now launch TDP, connect to Oracle, go to Data grid for a table that causes error, and include the column in the list of the Updatable columns. > Switch back to Toad for Oracle and go to Database| Monitor | SQL Tracker. In the opened form select TDP and start monitoring by pressing the Start Monitoring button or using Process| Start Monitoring menu item. Now we will get all SQL statements that TDP sends to Oracle. > Switch back to TDP and try to reproduce the error. At the same time you should get in Monitoring window something similar to the following screenshot > > Could you post the screenshot with the statement that causes the error? > Thanks > Aleksey > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43196.aspx?AbuseContentId=7c218e1e-8165-4e03-a5d1-19ae747ed57c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [January 17, 2014, 11:08am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/13 "2014-01-17T11:08:47Z")
Could you please repost the screenshot? It’s too small and I cannot read it. Thanks Aleksey ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [January 17, 2014, 11:18am UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/14 "2014-01-17T11:18:01Z")
Aleksey, I have attached it this time. Download and open it so you can see it full size. Jon On Fri, Jan 17, 2014 at 11:09 AM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43695.aspx#43695)** > Reply by Aleksey Bazhenov > Could you please repost the screenshot? > It’s too small and I cannot read it. > Thanks > Aleksey > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43695.aspx?AbuseContentId=4f575244-8948-4b02-99f1-1f27627e2db3&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [January 17, 2014, 12:17pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/15 "2014-01-17T12:17:06Z")
Thanks Joe, I’m sorry but I still cannot see well. For me it looks like you got the error for a different field – INVOICE\_ (I cannot see full name) and the size is 13-14 characters. Also when we update from a grid we always use bind variables and statement should look like on my screenshot from 18 Dec 2013 at 5:09pm. Here you get something else. Aleksey ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [January 17, 2014, 1:25pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/16 "2014-01-17T13:25:01Z")
Aleksey, As I indicated in a previous email, this error occurs on several tables, not just the table I sent in the previous sample. In regards to always using bind variables, I am not sure why mine would look different, but I am updating from a grid in Data Point, and that is what is showing up in SqlTracker, so I am not sure what your point is unless there is a setting you are referring to. All I know is that I update the grid and get the error that is show both in sqltracker and in Data Point. I followed your steps exactly and that is the result. Attached is a clearer image I split it so you can see the entire text. Jon On Fri, Jan 17, 2014 at 12:17 PM, Aleksey Bazhenov [bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43697.aspx#43697)** > Reply by Aleksey Bazhenov > Thanks Joe, > I'm sorry but I still cannot see well. > For me it looks like you got the error for a different field – INVOICE\_ (I cannot see full name) and the size is 13-14 characters. > Also when we update from a grid we always use bind variables and statement should look like on my screenshot from 18 Dec 2013 at 5:09pm. Here you get something else. > Aleksey > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43697.aspx?AbuseContentId=957bf0f8-56b3-4222-88cf-d186ba7a3315&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106 ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [January 17, 2014, 2:06pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/17 "2014-01-17T14:06:28Z")
I tried this using the original DDL provded and the maximum values for all varchars and cannot reproduce this issue. What is the encoding of this database? UTF-8, unicode, etc? And what is your OCI client set to? ---
**Author:** ![jonk\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jonk_187/32/10763_2.png) [@jonk\_187](https://forums.toadworld.com/u/jonk_187)\ **Post date:** [January 17, 2014, 3:02pm UTC](https://forums.toadworld.com/t/cant-update-table-data-in-database-explorer/27963/18 "2014-01-17T15:02:02Z")
Debbie, The database is UTF16 (NLS\_NCHAR\_CHARACTERSET = AL16UTF16 NS\_LANG = WE8MSWIN1252). The pc's NS\_LANG is WE8MSWIN1252. We use the same version of the Oracle client on all of our 12 Data Point installations with the exact same settings. This table has existed in our database for 8+ years and worked perfectly until we updated to Data Point 3.4 and now several of our tables cannot be updated using Data Point. I installed Toad for Oracle beside Data Point on the same computer and it has no problem updating data in the schema browser similar to how it is done in Data Point. I believe the only way to change the charset is when a call is made to OCIEnvCreate() and indicating a different charset than that which the computer uses as it's default and that would have to be done by calling OCI directly (I am sure Data Point is not doing this as it uses DevArt's Oracle client) Thanks for your assistance with this issue. Jon King On Fri, Jan 17, 2014 at 2:06 PM, Debbie Peabody [bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com) wrote: > **[RE: Can't update table data in Database Explorer](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43700.aspx#43700)** > Reply by Debbie Peabody > I tried this using the original DDL provded and the maximum values for all varchars and cannot reproduce this issue. What is the encoding of this database? UTF-8, unicode, etc? And what is your OCI client set to? > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/20923.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36.aspx?subscribe=false) notifications altogether. > > Toad Data Point - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/20923/43700.aspx?AbuseContentId=8614555d-538a-4c32-b075-91dd7633c817&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Jon King V. P. Enterprise Systems Development HPSI Cell: (801) 885-3301 Office: (949) 250-4774 ext. 106