ORA-29283: invalid file operation - why?
My database is 11.2.0.3
I am getting this error
1 DECLARE
2 v_outfile UTL_FILE.FILE_TYPE;
3 v_msg VARCHAR2(1530);
4 v_username VARCHAR2(130);
5 v_command VARCHAR2(130);
6 v_schemaname VARCHAR2(130);
7 v_osuser VARCHAR2(130);
8 v_machine VARCHAR2(130);
9 v_terminal VARCHAR2(130);
10 v_program VARCHAR2(160);
11 v_module VARCHAR2(160);
12 v_logon_time TIMESTAMP;
13 v_event VARCHAR2(130);
14 v_dt VARCHAR2(120);
15 -- Added directory_name for UTL_FILE changes, EXADATA Project
16
17
18 v_log_dir VARCHAR2(130) := 'SPO_LOG_DIR';
19
20
21 v_file_nm VARCHAR2(130) := 'user_status_oracle.log';
22
23
24 BEGIN
25 v_outfile := UTL_FILE.FOPEN(v_log_dir, v_file_nm, 'a');
26 v_dt := to_char(sysdate, 'MM/DD/YY HH24:MI:SS');