61:
62: g_Msg_Text VARCHAR2(1000);
63:
64: -- Log directory
65: g_Log_Dir v$parameter.value%TYPE;
66: g_Dump_Dir v$parameter.value%TYPE;
67:
68: -- Log files for Sqlplus
69: g_Log_File VARCHAR2(30) := 'eam_text_index.log';
62: g_Msg_Text VARCHAR2(1000);
63:
64: -- Log directory
65: g_Log_Dir v$parameter.value%TYPE;
66: g_Dump_Dir v$parameter.value%TYPE;
67:
68: -- Log files for Sqlplus
69: g_Log_File VARCHAR2(30) := 'eam_text_index.log';
70: g_Out_File VARCHAR2(30) := 'eam_text_index.out';
166: -- Determine log directory
167:
168: BEGIN
169: SELECT value INTO g_Dump_Dir
170: FROM v$parameter WHERE name = 'user_dump_dest';
171:
172: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
173: FROM v$parameter
174: WHERE name = 'utl_file_dir';
169: SELECT value INTO g_Dump_Dir
170: FROM v$parameter WHERE name = 'user_dump_dest';
171:
172: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
173: FROM v$parameter
174: WHERE name = 'utl_file_dir';
175:
176: IF ( g_Log_Dir IS NOT NULL ) THEN
177: IF ( INSTR(g_Log_Dir, ' ') > 0 ) THEN