Should Be Simple Right

presume

x.text :=3D 'blah BLAH DBMS_OUTPUT.put_line(''foo'');'

The following line...

x.text :=3D replace(x.text,'dbms_output.put_line','pltrack.put_line');

does not work because DBMS_OUTPUT is upper case.

I want this to work and the easiest method I see is to use UPPER or LOWER but then I have change the entire line and I do not want to do that. Beside that I have to do some sort of INSTR, SUBSTR which I can do but I am hoping there is any easier way to do replace with case insensitivity.

Oracle 9.2.0.4

--
http://www.freelists.org/webpage/oracle-l