Re: designer2000 HELP .. DATABASE DESIGN WIZARD ERROR

On 17 Jun 1998 16:57:25 GMT, "Eduardo verdia" <eduardo_at_iglobal.es> wrote:

>Hello all
>
>We have a problem with the database design wizard
>
>We have an entity relationship with 30 entities ...some of then are
>subtypes of another ...
>
>When we begin to generate...the wizard write this:
>
> 'Posting preferences to database....
> create table-entity 'E2:E2'
> Posting multi line text for table 'E2' to the reporsitory
>
> *** here is the error:
>
> ORA-06502:PL/SQL: numeric or value error
> ORA-06512:at 'EDU.RMMTXI' line 624
> ORA-06512:at 'EDU.RMMTXI' line 356
> ORA-06512:at 'EDU.RMMTX ' line 75
> ORA-06512:at 'EDU.RMOTEXT' line 80
> ORA-06512:at line 624
>
>Where E2 is an entity ( subtype of E with an atributte( varchar2 (2000),
> EDU is the designer2000 repository owner.
>Server side: Oracle 8.0.4 in NT 4.0
>Client side : Designer 2000 1.3.2
>
>...thanks

We had problems with texts (descriptions, notes) that were more than 80 characters per line. Parts of designer will not accept these. We used something like this to find them: select txt_text from cdi_text where length(txt_text) > 80;

Hope this helps
Roland. Received on Mon Jun 22 1998 - 19:45:14 CEST