DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on V$PARAMETER

Line 359: FROM V$PARAMETER

355: PROCEDURE open_debug_session_internal IS
356:
357: CURSOR c_get_utl_file_dir IS
358: SELECT VALUE
359: FROM V$PARAMETER
360: WHERE NAME = 'utl_file_dir';
361:
362: --local variables
363: --bug 12868802 UTL_FILE_DIR length defined in ORA.init can be longer than 512 in 10g or later,

Line 364: --so it may cause ORA-06502, replace with v$parameter.value%TYPE; which work in all cases.

360: WHERE NAME = 'utl_file_dir';
361:
362: --local variables
363: --bug 12868802 UTL_FILE_DIR length defined in ORA.init can be longer than 512 in 10g or later,
364: --so it may cause ORA-06502, replace with v$parameter.value%TYPE; which work in all cases.
365:
366: l_log_output_dir v$parameter.value%TYPE;
367: l_log_return_status VARCHAR2(99);
368: l_errbuff VARCHAR2(999);

Line 366: l_log_output_dir v$parameter.value%TYPE;

362: --local variables
363: --bug 12868802 UTL_FILE_DIR length defined in ORA.init can be longer than 512 in 10g or later,
364: --so it may cause ORA-06502, replace with v$parameter.value%TYPE; which work in all cases.
365:
366: l_log_output_dir v$parameter.value%TYPE;
367: l_log_return_status VARCHAR2(99);
368: l_errbuff VARCHAR2(999);
369: BEGIN
370: