DBA Data[Home] [Help]

APPS.MSC_PHUB_PKG dependencies on V$PARAMETER2

Line 52: from (select value from v$parameter2 where name='utl_file_dir'

48: g_log_row := g_log_row + 1;
49: if (g_log_file_name is null) then
50: select ltrim(rtrim(value))
51: into g_log_file_dir
52: from (select value from v$parameter2 where name='utl_file_dir'
53: order by rownum desc)
54: where rownum <2;
55: g_log_file_name := 'msc-phub.txt';
56: g_log_file_handle := utl_file.fopen(g_log_file_dir, g_log_file_name, 'w');