27:
28: if P_FILE is null then
29: -- select substr('l'|| substr(to_char(sysdate,'MI'),1,1)
30: -- || lpad(iex_debug_file_s.nextval,6,'0'),1,8) || '.IEX'
31: --into G_FILE from dual;
32:
33: SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
34: FROM DUAL;
35:
30: -- || lpad(iex_debug_file_s.nextval,6,'0'),1,8) || '.IEX'
31: --into G_FILE from dual;
32:
33: SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
34: FROM DUAL;
35:
36: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
37: else
38: G_FILE :=P_File;