Re: Designer 2K Problem with form Generation

Ron Loxton wrote:
>
> When I try to generate a module (form 4.5) from the designer the
> following error occurs:
>
> CGEN-00003: ERROR: SYSTEM: Location cggdes (overflow in varchar).
>
> This occurs on forms that use the column LAB_DESCRIPTION VARCHAR2(30).
> If I remove this usage from the module defn the form compiles fine.
> Anyone else had this problem.
>
> Thx
>
> Ron

Ron,

I ran into this problem a couple of days ago. ORACLE support said it was caused by a column description of over 70 characters. Here's what I found.

The description actually had to be over 74 characters. I generated a module several times with a description of 70 characters, after I removed the usage of the column with the longer description.

You cannot manually enter a description over 74 characters where this problem occurs. If you try to, the RON, etc. pops open a window and breaks up your description into separate lines.

All errors that caused this problem for me were generated by Designer 2000 itself for any column that we reverse engineered that had long enough table and column names to cause the generated description to be greater than 74 characters.

This is an ORACLE problem. I am just formulating a message to them about this today. I don't think they know it is a probkem with Des2K. Although I would bet you could also cause this problem if you populated the description using SQL*Plus outside Des2K (or other tool like SQL*Loader). Contact ORACLE support. They know about this problem.

Here's what I did to fix my problem. Bring up the column and its properties in the RON. Click on the description property. Click on the little bubble icon so the text editing window pops up. Change any thing in the description, such as add a character, then delete it. You will notice that the description will jump to two lines when you do. Save this description. Your problem is fixed. ORACLE support gave us a select statement to use to find candidates for this problem as follows:

select DSC_DESCRIPTION from sysdmt.SDD_DESCRIPTIONS

   where length(DSC_DESCRIPTION) > 70;

I think you need DBA privileges to run this select. Change sysdmt to the owner of your repository tables. And I found 74 was the magic number, not 70.

Good luck. Received on Mon Jan 13 1997 - 00:00:00 CET