Look for error in your ugoLogging.debug('test') function.

Originally posted by adcworks

1)
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at "SCHEMANAME.PKGNAME", line 12
ORA-06512: at line 1

2) Tried the old way

ALTER SYSTEM SET utl_file_dir = '/path/to/logdir' SCOPE=SPFILE

rebooted instance for luck.

Using a slightly difference debug procedure gives me;

SQL> exec ugoLogging.debug('test');
BEGIN pkgname.debug('test'); END;

*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 439
ORA-29283: invalid file operation
ORA-06512: at "SCHEMENAME.PKGNAME", line 37
ORA-06512: at line 1

==================