Re: designer problem RME-00020: Internal API error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Date: Tue, 15 Jan 2008 10:46:21 +0100
> 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
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 upReceived on Tue Jan 15 2008 - 10:46:21 CET