Re: designer problem RME-00020: Internal API error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Joolz wrote:
> Hello everybody,
>
> I'm new to Oracle, come from a PostgreSQL /Python environment, and I'm
> following a training in Oracle / Designer etc. (mostly self-study).
>
> I have a problem in Designer. It seems that when it wants to store
> information about diagrams I make a database error occurs. I found
> this link
> http://forums.oracle.com/forums/thread.jspa?threadID=284633&tstart=105
> but there isn't any mention of a solution.
>
> Does anyone know how to solve this, or how I can get access to Oracle
> bugs? TIA!

State your version of Designer (5 digits - not Designer 10G), and the version of database, you have your repository in.

Bugs can be accessed through metalink, the oracle support site.

The thread you mention, has:
- a workaround
- a bug number

Another workaround would be to run the following as repository owner:
update ci_diagrams

        set title = substr(title, 1, 40),
             name = substr(name,  1, 40),
           author = substr(author,1, 30)
        where length(title)  > 40
           or length(name)   > 40
           or length(author) > 30

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up