MDSYS.SDO_ROUTER_PARTITION dependencies on SDO_UTIL

Line 22: utl_file.put_line (part_log_file, sdo_util.number_to_char(sysdate,'Dy fmMon DD HH24:MI:SS YYYY'));

18: if ( utl_file.is_open(part_log_file) = FALSE ) then
19: return;
20: end if;
21: IF ( show_time ) THEN
22: utl_file.put_line (part_log_file, sdo_util.number_to_char(sysdate,'Dy fmMon DD HH24:MI:SS YYYY'));
23: END IF;
24:
25: utl_file.put_line (part_log_file, message);
26: utl_file.fflush(part_log_file);

Line 487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);

483: ' STORAGE (maxextents unlimited), NOLOGGING as
484: SELECT * FROM partition_tmp_3 WHERE p_id=' || part_counter;
485: EXECUTE IMMEDIATE stmt;
486:
487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);
488:
489: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
491: END IF;

Line 494: SELECT * FROM partition_tmp_3 WHERE p_id=' || sdo_util.number_to_char(part_counter+1);

490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
491: END IF;
492: stmt := 'CREATE TABLE ' || table_name ||
493: ' STORAGE (maxextents unlimited), NOLOGGING as
494: SELECT * FROM partition_tmp_3 WHERE p_id=' || sdo_util.number_to_char(part_counter+1);
495: EXECUTE IMMEDIATE stmt;
496:
497: COMMIT;
498: ELSE

Line 574: sdo_util.number_to_char((sysdate-p_date)*24*60,'99999.999') || ' min.',show_time) ;

570: log_message('INFO: partitioning '|| p_tab_name ||
571: ' level: ' || i || ' partition id: ' || pid);
572: -- add computation time form each level
573: log_message('INFO: partitioning level: ' || i || ' with ' || power(2,i+1) || ' partitions '|| ' took ' ||
574: sdo_util.number_to_char((sysdate-p_date)*24*60,'99999.999') || ' min.',show_time) ;
575: END LOOP;
576: END LOOP;
577:
578: -- Copy the result back to original table and ajust the pids

Line 1797: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');

1793: END IF;
1794:
1795: -- Validate the ending partition id.
1796: IF ((l_end_pid < start_pid) OR (l_end_pid > max_pid) OR (l_end_pid < 0)) THEN
1797: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');
1798: utl_file.fclose(part_log_file);
1799:
1800: RAISE PARAMETER_ERROR;
1801: END IF;

Line 1878: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||

1874: END IF;
1875:
1876: -- Validate the ending partition id.
1877: IF ((l_end_pid < start_pid) OR (l_end_pid > max_pid) OR (l_end_pid < 0)) THEN
1878: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||
1879: ', Valid Range ('||start_pid||','||max_pid||')');
1880: utl_file.fclose(part_log_file);
1881:
1882: RAISE PARAMETER_ERROR;

Line 2096: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');

2092: END IF;
2093:
2094: -- Validate the ending partition id.
2095: IF ((l_end_pid < start_pid) OR (l_end_pid > max_pid) OR (l_end_pid < 0)) THEN
2096: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');
2097: utl_file.fclose(part_log_file);
2098:
2099: RAISE PARAMETER_ERROR;
2100: END IF;

Line 2322: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');

2318: END IF;
2319:
2320: -- Validate the ending partition id.
2321: IF ((l_end_pid < start_pid) OR (l_end_pid > max_pid) OR (l_end_pid < 0)) THEN
2322: log_message('ERROR: Invald End Partition ID '||sdo_util.number_to_char(end_pid)||', Valid Range ('||start_pid||','||max_pid||')');
2323: utl_file.fclose(part_log_file);
2324:
2325: RAISE PARAMETER_ERROR;
2326: END IF;