1590: PROCEDURE open_debug_session IS
1591:
1592: CURSOR c_get_utl_file_dir IS
1593: SELECT VALUE
1594: FROM V$PARAMETER
1595: WHERE NAME = 'utl_file_dir';
1596:
1597: --local variables
1598: --EMTAPIA: modified length of varchar l_log_output_dir from 200 to 200 for bug: 7041983
1597: --local variables
1598: --EMTAPIA: modified length of varchar l_log_output_dir from 200 to 200 for bug: 7041983
1599: --l_log_output_dir VARCHAR2(200);
1600: -- Bug 13074883 swuppala : Replaced teh varchar2(2000) with the datatype
1601: l_log_output_dir v$parameter.value%type;
1602: l_log_return_status VARCHAR2(99);
1603: l_errbuff VARCHAR2(999);
1604: BEGIN
1605:
1897: -- Select the directory where the error log file needs to be saved
1898: --
1899: CURSOR c_get_utl_file_dir IS
1900: SELECT VALUE
1901: FROM V$PARAMETER
1902: WHERE NAME = 'utl_file_dir';
1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;