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

From: Frank van Bortel <>
Date: Tue, 15 Jan 2008 10:46:21 +0100
Message-ID: <3deb4$478c80ee$524b5c40$>

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
> 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

Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Tue Jan 15 2008 - 10:46:21 CET

Original text of this message