Re: Stored procedure Bulk replace

From: Laura <f.marchioni_at_pride.it>
Date: 4 May 2007 02:28:46 -0700
Message-ID: <1178270926.856765.165280@c35g2000hsg.googlegroups.com>

On 3 Mag, 17:44, DA Morgan <damor..._at_psoug.org> wrote:
> Laura wrote:
> > Hi all!
> > I have the need to replace all occurrences of a string in all stored
> > procedures of one user.
> > is it possible to do it ?
>
> > in practice we have an Oracle based application which uses Oracle
> > cartidge to produce html
>
> > Since Oracle cartridge will be dismissed we have to change all the
> > cartridge Api with some other instructions.
>
> > In this example :
>
> > CREATE OR REPLACE PACKAGE BODY dummy AS
> > .........) IS
> > BEGIN
>
> > htp.p('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//
> > EN">');
> > htp.p('<html><head><title>WIND R.D.C.P. MENU</title></head>');
> > htp.p('<frameset rows="70,*" framespacing="0" frameborder="0"
> > style="border-color : Silver
>
> > I need to replace "ht.p" instructions with something else (f.e.
> > displayHtml() )
>
> > How to do it ?
> > Thanks
> > Francesco
>
> Get the source code.
> Replace with the editing tool of your choice.
> Compile when no one is using the application.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

Hello!
thanks for your reply.
As a matter of fact I think Toad is the easiest choice. Anyway I was wondering if there's a way to do a "ReplaceAll" function to modify all stored procedures in one shot.
Is it possible to do it with Toad ?

If that is not possible with Toad I think I'll write a script that uses dbms_metadata to bulk replace all procs.......

Thanks again
francesco Received on Fri May 04 2007 - 04:28:46 CDT