Invoking a function call in a string in an Oracle Procedure
Posted
by DMS
on Stack Overflow
See other posts from Stack Overflow
or by DMS
Published on 2010-05-27T07:17:12Z
Indexed on
2010/05/27
7:21 UTC
Read the original article
Hit count: 228
Hello, I writing an application using Oracle 10g.
I am currently facing this problem. I take in "filename" as parameter of type varchar2.
A sample value that filename may contain is: 'TEST || to_char(sysdate, 'DDD')'.
In the procedure, I want to get the value of this file name as in TEST147. When i write:
select filename
into ffilename
from dual;
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?
Help appreciated. Thanks.
© Stack Overflow or respective owner
