MDSYS.SDO_ROUTER_PARTITION dependencies on ALL_DIRECTORIES

Line 46: stmt := 'SELECT directory_path FROM all_directories

42: IF (NOT utl_file.is_open(part_log_file)) THEN
43: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
44: END IF;
45:
46: stmt := 'SELECT directory_path FROM all_directories
47: WHERE directory_name=''SDO_ROUTER_LOG_DIR''';
48: EXECUTE IMMEDIATE stmt into full_file_name;
49:
50: -- Make sure the path is terminated with a /

Line 101: FROM all_directories

97:
98: if (new_dir_path is NULL)
99: then
100: SELECT COUNT(*) INTO row_count
101: FROM all_directories
102: WHERE directory_name = 'SDO_ROUTER_LOG_DIR';
103:
104: -- If SDO_ROUTER_LOG_DIR does not already exist the new_dir_path parameter
105: -- must be specified. Raise an error if the directory does not exist and

Line 112: FROM all_directories

108: then raise_application_error(-20012, '[ERROR] SDO_ROUTER_LOG_DIR directory does not exist');
109: end if;
110:
111: SELECT directory_path INTO directory_path
112: FROM all_directories
113: WHERE directory_name = 'SDO_ROUTER_LOG_DIR';
114:
115: directory_path := replace(directory_path, '\', '/');
116: else