Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procedure Bulk replace

Re: Stored procedure Bulk replace

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 03 May 2007 08:44:00 -0700
Message-ID: <1178207038.8655@bubbleator.drizzle.com>


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.org
Received on Thu May 03 2007 - 10:44:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US