replacing characters in PL/SQL

[megabyte214]

I am trying to use the replace function to replace a single quote " ' " with a backwards single quote " ` ".

tempT := replace(SRCSTR => tempT,OLDSUB => ''',NEWSUB => '`');

This code produces a compile error:
Error: PLS-00103: Encountered the symbol "`" when expecting one of the following:

. ( ) , * @ % & = - + < / > at in is mod not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like between ||

Any suggestions as to what I am doing wrong?

 

[SantaMufasa]

Megabyte,

Within a matching pair of single quotes, you must code two successive single quotes to produce one single quote. So, if the rest of your code is correct, then the following should produce the result you want:

tempT := replace(SRCSTR => tempT,OLDSUB => '''',NEWSUB => '`');

Let us know your findings,

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:07 (24Sep04) UTC (aka "GMT" and "Zulu"), 09:07 (24Sep04) Mountain Time)