SQL & PL/SQL

hello,
I need to create a logfile with name YYYYMMDD.log into c:\mydir\MYPARAM\

In my oracle package I've written this (not working) code:



FUNCTION mysf (parm IN VARCHAR2) RETURN INTEGER IS

logfile utl_file.file_type;
myline VARCHAR2(200);
logdir VARCHAR2(200);
v_logfile VARCHAR2(50);

BEGIN

DBMS_OUTPUT.ENABLE;

logdir := 'c:\mydir\' || parm || '\';

sql_txt := 'SELECT TO_CHAR(sysdate, ''yyyymmdd'') FROM DUAL';
EXECUTE IMMEDIATE sql_txt INTO v_logfile;

logfile := utl_file.fopen(logdir, v_logfile || '.log', 'A');

myline := 'bla bla';
utl_file.put_line(logfile, myline);

...


but no file is created...anything....

what is my mistake?

thanks a lot

Edited by: itmick on 11-mar-2010 6.15

Edited by: itmick on 11-mar-2010 6.15

Edited by: itmick on 11-mar-2010 6.15