Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procedure Bulk replace
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu May 03 2007 - 10:44:00 CDT
![]() |
![]() |