Re: 8.1.7 + Designer 6.0 --> A bug ?

Hello Walter
this is Server bug 1396675 on Oracle 8.1.7

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');

worked for me in Designer 2.1 and Designer 6.0 and Designer 6.1 on 8.1.7 for NT.

HTH
Günter

Walter Pircali schrieb:
>
> Hi to all,
>
> we have an Win2kServer SP1 with an 8.1.7 over it and 3 instances.
> We use one of this instance for Oracle Designer 6.0.
> As soon as we try to create the oracle designer repository it starts
> to make all, and then on package CIOUELEMENT_TYPE it hangs (CPU 100%).
>
> Initially I've thought it was win2k, so I've tried with NT 4.0 SP6 but
> it's
> the same. I've tried to recompile it manually ... nothing (CPU 100% and
> stop).
>
> I've take a look at metalink and technet ... nothing !
>
> Someone of you have had the same problem ? (or no problem at all ?)
>
> Thanks in advice for every answer
>
> bye
 

-- 
---------------------------------------------------------------
Dipl.-Inform.  Günter Huerkamp

Web        : http://gh.notrix.de

Email
privat     : mailto:guenter-huerkamp_at_web.de
privat     : mailto:guenter-huerkamp_at_t-online.de  
dienstlich : mailto:Guenter.Huerkamp_at_lk-wl.nrw.de


---------------------------------------------------------------