DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on V$PARAMETER

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

16698: ) IS
16699:
16700: --local variables
16701: --bug 12868802 UTL_FILE_DIR length defined in ORA.init can be longer than 512 in 10g or later,
16702: --so it may cause ORA-06502, replace with v$parameter.value%TYPE; which work in all cases.
16703:
16704:
16705: l_output_dir v$parameter.value%TYPE;
16706: l_return_status VARCHAR2(1);

Line 16705: l_output_dir v$parameter.value%TYPE;

16701: --bug 12868802 UTL_FILE_DIR length defined in ORA.init can be longer than 512 in 10g or later,
16702: --so it may cause ORA-06502, replace with v$parameter.value%TYPE; which work in all cases.
16703:
16704:
16705: l_output_dir v$parameter.value%TYPE;
16706: l_return_status VARCHAR2(1);
16707: l_error_mesg VARCHAR2(512);
16708:
16709: BEGIN

Line 16717: FROM V$PARAMETER

16713: IF (p_debug_level > 0) THEN
16714:
16715: SELECT VALUE
16716: INTO l_output_dir
16717: FROM V$PARAMETER
16718: WHERE NAME = 'utl_file_dir';
16719:
16720: ---------------------------------------
16721: -- This global holds the debug level --