Re: help, designer 6i repository installation

From: Guenter Huerkamp <guenter-huerkamp_at_t-online.de>
Date: Mon, 17 Sep 2001 18:39:08 +0200
Message-ID: <3BA6272C.9060708_at_t-online.de>


I think you must install Designer 6i Rel. 2 (Version 6.5.40.2.0) because there is a
  Server bug 1396675 on Oracle 8.1.7 with 6i.

OR you can edit and
find this in package cioue_element_type

  delete from sdd_reserved_names

  where (rn_res_name, rn_type) in ((upper(view_name), 'VIEW')
                                  ,(upper(pack_name), 'PACKAGE')
                                  ,(upper(pack_name), 'PACKAGE BODY'));

and replace it with

     view_name := upper(view_name);
     pack_name := upper(pack_name);
     app_view_name := upper(app_view_name);

     -- Remove Reserved Names entry and comment
     delete from sdd_reserved_names
      where (rn_res_name = view_name and rn_type = 'VIEW')
         or (rn_res_name = pack_name and rn_type = 'PACKAGE')
         or (rn_res_name = pack_name and rn_type = 'PACKAGE BODY');


This worked for me.
Hth
Günter

Paul B. wrote:

> Must be 6i Release 2 at least for 8.1.7. DB.
> Refer the compatibility matrix on Oracle Metalink.
>
> Paul
>
> "beze veze" <pismonosa_at_net.hr> píše v diskusním příspěvku
> news:9nicnf$54ja$1_at_as201.hinet.hr...
>

>>my instalation freezes every time I try to install cioue_element_type
>>package body, I installed and fixed everything else..... plz help
>>THX
>>
>>
>>

>
>
Received on Mon Sep 17 2001 - 18:39:08 CEST

Original text of this message