29:
30: g_Msg_Text VARCHAR2(1000);
31:
32: -- Log directory
33: g_Log_Dir v$parameter.value%TYPE;
34: g_Dump_Dir v$parameter.value%TYPE;
35:
36: -- Log files for Sqlplus
37: g_Log_File VARCHAR2(30) := 'ego_item_text_tl_srs.log';
30: g_Msg_Text VARCHAR2(1000);
31:
32: -- Log directory
33: g_Log_Dir v$parameter.value%TYPE;
34: g_Dump_Dir v$parameter.value%TYPE;
35:
36: -- Log files for Sqlplus
37: g_Log_File VARCHAR2(30) := 'ego_item_text_tl_srs.log';
38: g_Out_File VARCHAR2(30) := 'ego_item_text_tl_srs.out';
113: -- Determine log directory
114:
115: BEGIN
116: SELECT value INTO g_Dump_Dir
117: FROM v$parameter WHERE name = 'user_dump_dest';
118:
119: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
120: FROM v$parameter
121: WHERE name = 'utl_file_dir';
116: SELECT value INTO g_Dump_Dir
117: FROM v$parameter WHERE name = 'user_dump_dest';
118:
119: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
120: FROM v$parameter
121: WHERE name = 'utl_file_dir';
122:
123: IF ( g_Log_Dir IS NOT NULL ) THEN
124: IF ( INSTR(g_Log_Dir, ' ') > 0 ) THEN