Designer 3i & Oracle 8.1.7

From: Robert Konzelmann <r.konzelmann_at_impaq.ch>
Date: Mon, 11 Dec 2000 10:38:39 +0100
Message-ID: <3A34A09F.A17AFB91_at_impaq.ch>

I'm trying to install the repository for the new Designer 3i on my Computer, but till now I had no luck.
It seems to me, that the following statement in the 'cioue_element_type' procedure is the "bad guy":

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


                                   ,(upper(app_view_name), 'VIEW


BODY')); 

Because, as soon as a remove one element in the "in" cause, it works

fine
(e.g. 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'));


)

The problem is, that it returns no!!!! Error Message, it just stops, and [Quoted] I wait .........

Thanks
 Robert Received on Mon Dec 11 2000 - 10:38:39 CET