Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feed20.multikabel.net!multikabel.net!feed10.multikabel.net!feeder1.cambrium.nl!feed.tweaknews.nl!proxad.net!proxad.net!cleanfeed2-a.proxad.net!nnrp2-1.free.fr!not-for-mail
Date: Tue, 06 Jun 2006 15:22:36 +0200
From: Michelle <rr@somewhere.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: fr, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Designer 10g/XE - Repository Installation fails at CKSYSFOL
Content-Type: multipart/mixed;
 boundary="------------060905060305010903070007"
Lines: 124
Message-ID: <4485819a$0$12367$626a54ce@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 06 Jun 2006 15:22:34 MEST
NNTP-Posting-Host: 82.245.192.44
X-Trace: 1149600154 nnrp2-1.free.fr 12367 82.245.192.44:2872
X-Complaints-To: abuse@proxad.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:70930
--------------060905060305010903070007
Content-Type: text/plain;
 name="CKSYSFOL.lis"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="CKSYSFOL.lis"

Operation: Started :  06/06/06 14:10:26
Reading File: cksysfol.sql
Object      : CKSYSFOL CKSYSFOL
   Executing statement(s)...
Error Submitting Definition: User intervention required...
RME-02124: Failed to execute SQL statement:  
DECLARE 
   ar_irid                 number; 
   wkarea_irid		   number; 
   dummy_wrkarea           boolean := FALSE; 
   folder_irid             number; 
   folder_ivid             number; 
   org_irid                number; 
   org_ivid                number; 
   max_default_value_types number; 
   rtn_id                  number;  
   vat_type                number;   
   comment                 varchar2(100); 
   ps1_irid                number; 
   ps1_ivid                number; 
   l_SUPPORTS_DESIGNER     varchar2(1); 
   l_SUPPORTS_JDEVEE       varchar2(1); 
 
   TYPE t_Value_Type is record  
     ( name         varchar2(20)  
     , datatype     varchar2(20)  
     , lob_flag     varchar2(1)  
     , derived_from binary_integer  -- index number of source record  
     , irid         number          -- store irid for later use  
     ) ;  
  
   Type tt_Value_Type is table of t_Value_Type index by binary_integer;  
  
   init_value_types  tt_Value_Type;  
  
BEGIN 
  dbms_output.enable(1000000); 
 
  -- Added for Bug 1326447 
  update ck_installed_objects  
    set ci_created = 'N' 
  where ci_stage='CKSYSFOL'; 
  -- End addition for Bug 1326447 
   
  select SUPPORTS_JDEVEE 
  ,      SUPPORTS_DESIGNER 
  into   l_SUPPORTS_JDEVEE 
  ,      l_SUPPORTS_DESIGNER 
  from   rm$repositories; 
 
  -- Check Global Shared Workarea exists  
  dbms_output.put_line('* Checking if Global Shared Wokrarea exists' ); 
  begin 
    select irid 
    into wkarea_irid  
    from I$sdd_workareas  
    where name = 'GLOBAL SHARED WORKAREA'; 
  exception when no_data_found then  
    dummy_wrkarea := TRUE; 
 
    -- Create a dummy workarea to put the SYSTEM FOLDER in  
    wkarea_irid := jr_workarea.create_workarea( user,  
                                                'SYSTEM WORKAREA',  
                                                'Temporay WorkArea used to create the SYSTEM FOLDER'); 
  end; 
 
 
  -- Set workarea context 
  jr_context.set_workarea(wkarea_irid); 
 
  -- Now 
ORA-06512: à ligne 1270
ORA-04088: erreur lors d'exécution du déclencheur 'REPOS_MANAGER.SDD_FOLDERS_I'
ORA-06512: à "REPOS_MANAGER.SDD_FOLDERS_I", ligne 136
ORA-06512: à "REPOS_MANAGER.JR_FOLDER", ligne 535
ORA-06508: PL/SQL : unité de programme nommée : "REPOS_MANAGER.JR_REG_IO" introuvable
ORA-04063: package body "REPOS_MANAGER.JR_REG_IO" comporte des erreurs

--------------060905060305010903070007--