Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g56H5Cs29983 for ; Thu, 6 Jun 2002 13:05:12 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id BAA14319; Thu, 6 Jun 2002 01:56:56 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00475F3E; Thu, 06 Jun 2002 00:58:19 -0800 Message-ID: Date: Thu, 06 Jun 2002 00:58:19 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: G.Plivna@itsystems.lv Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: G.Plivna@itsystems.lv Subject: Re: rename package Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=Windows-1257 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by naude.co.za id g56H5Cs29983 Oh You may consider all these event triggers on create, on drop etc. Capture the previous code from data dictionary and store it in some table This is just an idea, not implemented procedure at least by me Gints Plivna IT Sistēmas, Merķeļa 13, LV1050 Rīga http://www.itsystems.lv/gints/ "BigP" otmail.com> cc: Sent by: Subject: rename package root@fatcity.com 2002.06.05 22:03 Please respond to ORACLE-L Hi Guys , Is it possible to rename a package , procedure and function . I want to create some undo procedure for every patch we apply on database . What approach you guys adapt ? Thanks , Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: G.Plivna@itsystems.lv Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).