title: Invoking a function call in a string in an Oracle Procedure
body: <p>I writing an application using Oracle 10g.</p>
  
  <p>I am currently facing this problem. I take in "filename" as parameter of type varchar2.</p>
  
  <p>A sample value that filename may contain is: 'TEST || to_char(sysdate, 'DDD')'.</p>
  
  <p>In the procedure, I want to get the value of this file name as in TEST147.
  When i write:</p>
  
  <pre><code>select filename
  into ffilename
  from dual;
  </code></pre>
  
  <p>I get the value ffilename = TEST || to_char(sysdate, 'DDD') whick makes sense. But how can I get around this issue and invoke the function in the string value?</p>
  
  <p>Help appreciated.
  Thanks.</p>