DBA Data[Home] [Help]

APPS.MSC_SCH_WB dependencies on V$PARAMETER2

Line 1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)

1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from
1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;
1016: /*bug 3374136 changes end*/
1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);