155: PROCEDURE open_debug_session_internal IS
156:
157: CURSOR c_get_utl_file_dir IS
158: SELECT VALUE
159: FROM V$PARAMETER
160: WHERE NAME = 'utl_file_dir';
161:
162: --local variables
163: -- Bug 13074883 swuppala : Modified the datatype with the database column datatype
160: WHERE NAME = 'utl_file_dir';
161:
162: --local variables
163: -- Bug 13074883 swuppala : Modified the datatype with the database column datatype
164: l_log_output_dir v$parameter.value%type;
165: l_log_return_status VARCHAR2(99);
166: l_errbuff VARCHAR2(999);
167: BEGIN
168: