Re: Error in the Repository for Designer/2000!

You are probably running on a version of the RDBMS that needs some patches. What version of the database server are you running?

yywong_at_math.hkbu.edu.hk (YyWong) wrote:

>Recently, I open my application in Designer/2000 and try to
>modify some function's attribute in the Function Hierarchy
>Diagrammer, some error messages occurs and didn't allow me to
>do any changes.
>At the same time, I found that my classmates also have the same
>problem on this and this error even occurs when a user creating
>a new application. The error messages are display as follows:
>
>============= Error Message from Designer/2000 =============
>RME-00222: Failed to dispatch operation to Repository
>RME-02124: Failed to execute SQL statement:
> declare
> pl1 CIOEVENT_TRIGGER.data;
> utility varchar2(3);
> begin
> rmmes.clear;
> savepoint rm_dispatch;
> pl1.i.ID := true;
> pl1.v.ID := :p2;
> pl1.i.TRIGGERED_EVENT_REFERENCE := true;
> pl1.v.TRIGGERED_EVENT_REFERENCE := :p3;
> pl1.i.TRIGGERED_FUNCTION_REFERENCE := true;
> pl1.v.TRIGGERED_FUNCTION_REFERENCE := :p4;
> pl1.i.TRIGGERING_EVENT_REFERENCE := true;
> pl1.v.TRIGGERING_EVENT_REFERENCE := :p5;
> pl1.i.TRIGGERING_FUNCTION_REFERENCE := true;
> pl1.v.TRIGGERING_FUNCTION_REFERENCE := :p6;
> CIOEVENT
>ORA-06502: PL/SQL: numeric or value error
>===================== End of Messages ====================
>
>Can anyone who know how can I or my DBA do to solve this
>problem?
>In fact, we have about 40 users who already create applications
>in the repository and didn't want to drop the whole things and
>re-install it.

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com

Don't miss the Oracle Development Tools User Group Conference in St. Louis, Nov. 2-5. See http://www.odtug.com for more information. Received on Thu Oct 16 1997 - 00:00:00 CEST