Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > Re: designer pr...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 4 Topic 2695 of 2833
Post > Topic >>

Re: designer problem RME-00020: Internal API error - ORA-06502: PL/SQL:

by Frank van Bortel <frank.van.bortel@[EMAIL PROTECTED] > Jan 15, 2008 at 10:46 AM

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 sup****t 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
 




 4 Posts in Topic:
designer problem RME-00020: Internal API error - ORA-06502: PL/S
Joolz <root@[EMAIL PRO  2008-01-15 09:03:59 
Re: designer problem RME-00020: Internal API error - ORA-06502:
Joolz <root@[EMAIL PRO  2008-01-15 09:44:06 
Re: designer problem RME-00020: Internal API error - ORA-06502:
Frank van Bortel <fran  2008-01-15 10:46:21 
Re: designer problem RME-00020: Internal API error - ORA-06502:
Joolz <root@[EMAIL PRO  2008-01-15 13:50:34 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 19:31:16 CST 2008.