Laura wrote:
> 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
I understood your original question thus my answer.
More explicitly: No.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri May 04 2007 - 10:39:03 CDT
