Problem with long comment when checking in

Toad for Oracle
1

Hello all,

When I want to check in sources into VCS and use a comment longer than 200 characters, there raises the following exception:

10:52:33 Error: ORA-12899: value too large for column "TOAD"."TCX_OBJECTS"."LAST_CHECKIN_COMMENTS" (actual: 201, maximum: 200) ORA-06512: at line 1

Can I enlarge the column LAST_CHECKIN_COMMENTS to e.g. 1000 characters without any other issues? And can TOAD team please enlarge the column size when creating the tables?

Thanks, and best regards from Germany
-Rainer

2

Any ideas what to do - see above???

3

Hi Rainer. We'll take a look and get back to you.

4

Hi Rainer. Following statements should take care of the exception and allow for longer check in/out comments:

alter table TOAD.TCX_OBJECTS modify (LAST_CHECKOUT_COMMENTS VARCHAR2(1000 CHAR), LAST_CHECKIN_COMMENTS VARCHAR2(1000 CHAR));

alter table TOAD.TCX_OBJECT_HISTORY modify (COMMENTS VARCHAR2(1000 CHAR));

We will also need to update Toad application to fully support new column lengths.

5

The workaround with enlarging the columns fixes the problem (I often use long comments :wink:). And in the Beta forum I saw that the columns will be resized to 1000 in TOAD 17.1

Perfect, thanks!