Stored procedure Bulk replace

From: Laura <f.marchioni_at_pride.it>
Date: 3 May 2007 07:36:00 -0700
Message-ID: <1178202960.210352.278320@u30g2000hsc.googlegroups.com>

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 Received on Thu May 03 2007 - 09:36:00 CDT