title: Unable to use REPLACE function in PLSQL
body: <p>I was wondering what is the appropriate way to call the <a href="http://www.techonthenet.com/oracle/functions/replace.php" rel="nofollow">REPLACE function described here</a>, since I've created the statement below to test it but I'm getting an error:</p>
  
  <pre><code>DECLARE
   templateMessage3 VARCHAR2(50);
  BEGIN
   templateMessage3 := 'Dear Mr./Madam FNAME';
    replace(templateMessage3, 'FNAME', 'Lilly');
    DBMS_OUTPUT.PUT_LINE(templateMessage3);
  END;
  /
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>PLS-00221: 'REPLACE' is not a procedure or is undefined
  </code></pre>
  
  <p>I am using Oracle 11g web interface.</p>