Designer Repository Installation - Error ORA-00604

From: Mark Casey <mcasey_at_pegasustech.com.au>
Date: Thu, 15 Jul 1999 11:35:27 +1000
Message-ID: <378D3ADF.91E7D601_at_pegasustech.com.au>



RME-02124: Failed to execute SQL statement: create or replace package body rmand as

procedure dispatch_query(cid IN number,tid IN number,eid IN number) is begin

  • Element type tcotme... if tid = 4811 then ciotype_constraint_component.traverse_to_root(cid,eid,true);
  • Element type abtabt... elsif tid = 4814 then ciogeneralisation_association.traverse_to_root(cid,eid,true);
  • Element type lst... elsif tid = 4816 then ciolob_storage.traverse_to_root(cid,eid,true);
  • Element type ort... elsif tid = 4819 then ciooracle_type.traverse_to_root(cid,eid,true);
  • Element type oot... elsif tid = 4820 then ciooracle_object_type.traverse_to_root(cid,eid,true);
  • Element type appcon... elsif tid = 4834 then cioapp_con_interface.traverse_to_root(cid,eid,true);
  • Element type itm... elsif tid = 4837 then ciodatastructure_item.traverse_to_root(cid,eid,true);
  • Element type dat... elsif tid = 4841 then ciodatastructure.traverse_to_root(cid,eid,true);
  • Element type dbu... elsif tid = 4856 then ciodatabase_user.traverse_to_root(cid,eid,true);
  • Element type dbugrp... elsif tid = 4857 then ciodatabase_user_role.traverse_to_root(cid,eid,true);
  • Element type ccd... elsif tid = 4863 then ciocluster_column.traverse_to_root(cid,eid,true);
  • Element type relend... elsif tid = 4865 then ciorelationship_end.traverse_to_root(cid,eid,true);
  • Element type vwtab... elsif tid = 4866 then ciorelation_selection.traverse_to_root(cid,eid,true);
  • Element type oco... elsif tid = 4867 then cioconstraint.traverse_to_root(cid,eid,true);
  • Element type ind... elsif tid = 4869 then cioindex.traverse_to_root(cid,eid,true);
  • Element type indcol... elsif tid = 4870 then cioindex_entry.traverse_to_root(cid,eid,true);
  • Element type mod... elsif tid = 4871 then ciomodule.traverse_to_root(cid,eid,true);
  • Element type modcol... elsif tid = 4872 then ciomodule_ RME-02123: Failed to parse SQL statement RME-02105: Oracle error occurred... ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 992 bytes of shared memory ("shared pool","select ts#,file#,block#,nvl(...","sql area","kafco : qkacol")

ORA-00604: error occurred at recursive SQL level Received on Thu Jul 15 1999 - 03:35:27 CEST

Original text of this message