If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 98
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at "SI.TEST_WRITE", line 8
ORA-06512: at line 1

-------------------------

By the way, how to write to the file with current date and time as the name of the file? Thanks!

Why? I don't see it like a security problem. Anyway, not much more of a security problem than it is with the old-fashioned UTL_FILE_DIR init parameter. You can do the same thing as you have demonstrated with UTL_FILE_DIR, if you set it to 'c:\oracle\bin' or '*' - where is the difference?

My point is: a responsible DBA would not use '*' or anything simmilar to '$ORACLE_HOME/bin' in the UTL_FILE_DIR. Similarly, a responsible DBA would create directories (as database objects) personaly, he/she would never give a CREATE ANY DIRECTORY privilege to an iresponsible DBA or (god forbid!) developer.

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?