eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MDSYS.SDO_ROUTER_PARTITION dependencies on UTL_FILE

Line 4: part_log_file utl_file.file_type := NULL;

1: PACKAGE BODY SDO_ROUTER_PARTITION AS
2:
3: -- Partitioning log file
4: part_log_file utl_file.file_type := NULL;
5: schema_name VARCHAR2(64) := NULL;
6: JAVA_ERROR EXCEPTION;
7: PARAMETER_ERROR EXCEPTION;
8:

Line 18: if ( utl_file.is_open(part_log_file) = FALSE ) then

14: PROCEDURE log_message(message IN VARCHAR2, show_time IN BOOLEAN DEFAULT TRUE)
15: IS
16: BEGIN
17:
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'));

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 25: utl_file.put_line (part_log_file, message);

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);
27:
28: EXCEPTION
29: WHEN OTHERS THEN

Line 26: utl_file.fflush(part_log_file);

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);
27:
28: EXCEPTION
29: WHEN OTHERS THEN
30: raise_application_error(-20002, 'PLSQL Error Writing Log File');

Line 42: IF (NOT utl_file.is_open(part_log_file)) THEN

38: BEGIN
39: BEGIN
40: -- Open the routers partition log file
41:
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

Line 43: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

39: BEGIN
40: -- Open the routers partition log file
41:
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''';

Line 58: WHEN utl_file.invalid_path THEN

54:
55: full_file_name := full_file_name || log_file_name;
56:
57: EXCEPTION
58: WHEN utl_file.invalid_path THEN
59: raise_application_error(-20006, '[ERROR] SDO_ROUTER_LOG_DIR directory not found');
60: WHEN utl_file.invalid_operation THEN
61: raise_application_error(-20006, '[ERROR] bad directory path specified for SDO_ROUTER_LOG_DIR directory');
62: WHEN OTHERS THEN

Line 60: WHEN utl_file.invalid_operation THEN

56:
57: EXCEPTION
58: WHEN utl_file.invalid_path THEN
59: raise_application_error(-20006, '[ERROR] SDO_ROUTER_LOG_DIR directory not found');
60: WHEN utl_file.invalid_operation THEN
61: raise_application_error(-20006, '[ERROR] bad directory path specified for SDO_ROUTER_LOG_DIR directory');
62: WHEN OTHERS THEN
63: raise_application_error(-20001, '[ERROR] could not open log file');
64: END;

Line 164: utl_file.fclose(part_log_file);

160: BEGIN
161: -- From PLSQL
162: full_file_name := open_log_file(log_file_name);
163: log_message('[INFO] PLSQL logging OK (' || schema_name || ')');
164: utl_file.fclose(part_log_file);
165:
166: -- From Java
167: elocation_validate_logfile(full_file_name, schema_name);
168:

Line 1534: utl_file.fclose(part_log_file);

1530: EXECUTE IMMEDIATE stmt USING l_network_name, 'LINK', 'F', 'NUMBER';
1531:
1532: COMMIT;
1533:
1534: utl_file.fclose(part_log_file);
1535: END;
1536:
1537: --
1538: -- Entry point to used to create a network on the Router data

Line 1606: utl_file.fclose(part_log_file);

1602: END IF;
1603:
1604: COMMIT;
1605:
1606: utl_file.fclose(part_log_file);
1607: END;
1608:
1609: --
1610: -- Entry point and driver of the entire partitioning process.

Line 1680: utl_file.fclose(part_log_file);

1676: create_restricted_edges;
1677: END IF;
1678:
1679: -- Close the log file so the Java code can use it
1680: utl_file.fclose(part_log_file);
1681:
1682: -- Adjust the Oracle JVM maximum memory size to 1.5g.
1683: -- This is the equivelent to specifying -Xmx1536m to
1684: -- java outside the database. Memory size is specified in bytes.

Line 1699: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1695: -- Java code to create the partiton table
1696: elocation_partition_router(full_file_name, msg_blob_format);
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1700: log_message(SQLERRM);
1701: utl_file.fclose(part_log_file);
1702: RAISE JAVA_ERROR;
1703: END;

Line 1701: utl_file.fclose(part_log_file);

1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1700: log_message(SQLERRM);
1701: utl_file.fclose(part_log_file);
1702: RAISE JAVA_ERROR;
1703: END;
1704:
1705: -- Reopen the logfile

Line 1706: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1702: RAISE JAVA_ERROR;
1703: END;
1704:
1705: -- Reopen the logfile
1706: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1707:
1708: log_message('INFO: creating the final partition table');
1709:
1710: -- Rename the new partition table and build an index on it.

Line 1737: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1733: create_trucking_data(log_file_name, TRUE);
1734: END IF;
1735:
1736: -- Reopen the logfile
1737: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1738: clean_tables(cleanup);
1739: log_message('******** Completed SDO Router partitioning');
1740:
1741: -- Close the log file

Line 1742: utl_file.fclose(part_log_file);

1738: clean_tables(cleanup);
1739: log_message('******** Completed SDO Router partitioning');
1740:
1741: -- Close the log file
1742: utl_file.fclose(part_log_file);
1743: EXCEPTION
1744: WHEN JAVA_ERROR THEN
1745: raise_application_error(-20000, 'Oracle Router partitioning failed');
1746: WHEN OTHERS THEN

Line 1747: IF (utl_file.is_open(part_log_file) = FALSE) THEN

1743: EXCEPTION
1744: WHEN JAVA_ERROR THEN
1745: raise_application_error(-20000, 'Oracle Router partitioning failed');
1746: WHEN OTHERS THEN
1747: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1748: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1749: END IF;
1750: log_message(SQLERRM);
1751: utl_file.fclose(part_log_file);

Line 1748: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1744: WHEN JAVA_ERROR THEN
1745: raise_application_error(-20000, 'Oracle Router partitioning failed');
1746: WHEN OTHERS THEN
1747: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1748: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1749: END IF;
1750: log_message(SQLERRM);
1751: utl_file.fclose(part_log_file);
1752: raise_application_error(-20000, 'Oracle Router partitioning failed');

Line 1751: utl_file.fclose(part_log_file);

1747: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1748: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1749: END IF;
1750: log_message(SQLERRM);
1751: utl_file.fclose(part_log_file);
1752: raise_application_error(-20000, 'Oracle Router partitioning failed');
1753: END partition_router;
1754:
1755: --

Line 1774: utl_file.fclose(part_log_file);

1770:
1771: -- Make sure the table is actually there
1772: IF (table_exists('PARTITION') = 'FALSE' ) THEN
1773: log_message('ERROR: Partition dump failed, PARTITION table not found');
1774: utl_file.fclose(part_log_file);
1775:
1776: RAISE PARAMETER_ERROR;
1777: END IF;
1778:

Line 1790: utl_file.fclose(part_log_file);

1786:
1787: -- Validate the starting partition id.
1788: IF ((start_pid < 0) OR (start_pid > max_pid)) THEN
1789: log_message('ERROR: Invald Start Partition ID '||start_pid||', Valid Range (0,'||max_pid||')');
1790: utl_file.fclose(part_log_file);
1791:
1792: RAISE PARAMETER_ERROR;
1793: END IF;
1794:

Line 1798: utl_file.fclose(part_log_file);

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;
1802:

Line 1818: utl_file.fclose(part_log_file);

1814:
1815: log_message('', FALSE);
1816:
1817: -- Close the log file so the Java code can use it
1818: utl_file.fclose(part_log_file);
1819:
1820: elocation_dump_partition(full_file_name, start_pid, l_end_pid,
1821: verbose, is_10g(version));
1822:

Line 1827: IF (utl_file.is_open(part_log_file) = FALSE) THEN

1823: EXCEPTION
1824: WHEN PARAMETER_ERROR THEN
1825: raise_application_error(-20004, 'Error, partition dump failed, see log file.');
1826: WHEN OTHERS THEN
1827: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1828: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1829: END IF;
1830: log_message(SQLERRM);
1831: utl_file.fclose(part_log_file);

Line 1828: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1824: WHEN PARAMETER_ERROR THEN
1825: raise_application_error(-20004, 'Error, partition dump failed, see log file.');
1826: WHEN OTHERS THEN
1827: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1828: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1829: END IF;
1830: log_message(SQLERRM);
1831: utl_file.fclose(part_log_file);
1832: raise_application_error(-20004, 'Error, partition dump failed, see log file.');

Line 1831: utl_file.fclose(part_log_file);

1827: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1828: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1829: END IF;
1830: log_message(SQLERRM);
1831: utl_file.fclose(part_log_file);
1832: raise_application_error(-20004, 'Error, partition dump failed, see log file.');
1833: END dump_partitions;
1834:
1835: --

Line 1854: utl_file.fclose(part_log_file);

1850:
1851: -- Make sure the table is actually there
1852: IF (table_exists('PARTITION') = 'FALSE' ) THEN
1853: log_message('ERROR: Partition validate failed, PARTITION table not found');
1854: utl_file.fclose(part_log_file);
1855:
1856: RAISE PARAMETER_ERROR;
1857: END IF;
1858:

Line 1871: utl_file.fclose(part_log_file);

1867: -- Validate the starting partition id.
1868: IF ((start_pid < 0) OR (start_pid > max_pid)) THEN
1869: log_message('ERROR: Invald Start Partition ID '||start_pid||
1870: ', Valid Range (0,'||max_pid||')');
1871: utl_file.fclose(part_log_file);
1872:
1873: RAISE PARAMETER_ERROR;
1874: END IF;
1875:

Line 1880: utl_file.fclose(part_log_file);

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;
1883: END IF;
1884:

Line 1900: utl_file.fclose(part_log_file);

1896: END IF;
1897: log_message('', FALSE);
1898:
1899: -- Close the log file so the Java code can use it
1900: utl_file.fclose(part_log_file);
1901:
1902: -- Adjust the Oracle JVM maximum memory size to 800M.
1903: -- This is the equivelent to specifying -Xmx800m to
1904: -- java outside the database. Memory size is specified in bytes.

Line 1914: IF (utl_file.is_open(part_log_file) = FALSE) THEN

1910: EXCEPTION
1911: WHEN PARAMETER_ERROR THEN
1912: raise_application_error(-20003, 'Error, partition validation failed, see log file.');
1913: WHEN OTHERS THEN
1914: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1915: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1916: END IF;
1917: log_message(SQLERRM);
1918: utl_file.fclose(part_log_file);

Line 1915: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1911: WHEN PARAMETER_ERROR THEN
1912: raise_application_error(-20003, 'Error, partition validation failed, see log file.');
1913: WHEN OTHERS THEN
1914: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1915: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1916: END IF;
1917: log_message(SQLERRM);
1918: utl_file.fclose(part_log_file);
1919: raise_application_error(-20003, 'Error, partition validation failed, see log file.');

Line 1918: utl_file.fclose(part_log_file);

1914: IF (utl_file.is_open(part_log_file) = FALSE) THEN
1915: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
1916: END IF;
1917: log_message(SQLERRM);
1918: utl_file.fclose(part_log_file);
1919: raise_application_error(-20003, 'Error, partition validation failed, see log file.');
1920: END;
1921:
1922:

Line 1989: utl_file.fclose(part_log_file);

1985: -- create an index on the partitioned datas partition_id field
1986: EXECUTE IMMEDIATE 'CREATE INDEX prt_p_idx ON partitioned_router_transport(partition_id)';
1987:
1988: -- Close the log file so the Java code can use it
1989: utl_file.fclose(part_log_file);
1990:
1991: -- Adjust the Oracle JVM maximum memory size to 800M.
1992: -- This is the equivelent to specifying -Xmx800m to
1993: -- java outside the database. Memory size is specified in bytes.

Line 2001: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

1997: -- Java code to partition the trucking data
1998: elocation_trucking_data(full_file_name);
1999: EXCEPTION
2000: WHEN OTHERS THEN
2001: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2002: log_message(SQLERRM);
2003: utl_file.fclose(part_log_file);
2004: RAISE JAVA_ERROR;
2005: END;

Line 2003: utl_file.fclose(part_log_file);

1999: EXCEPTION
2000: WHEN OTHERS THEN
2001: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2002: log_message(SQLERRM);
2003: utl_file.fclose(part_log_file);
2004: RAISE JAVA_ERROR;
2005: END;
2006:
2007: -- Reopen the logfile

Line 2008: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2004: RAISE JAVA_ERROR;
2005: END;
2006:
2007: -- Reopen the logfile
2008: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2009:
2010: log_message('INFO: creating the final trucking user data table');
2011:
2012: -- Rename the new partition table and build an index on it.

Line 2040: utl_file.fclose(part_log_file);

2036:
2037: log_message('******** Completed generation of trucking user data ');
2038:
2039: -- Close the log file
2040: utl_file.fclose(part_log_file);
2041: EXCEPTION
2042: WHEN JAVA_ERROR THEN
2043: raise_application_error(-20015, 'Oracle Router trucking user data generation failed');
2044: WHEN OTHERS THEN

Line 2045: IF (utl_file.is_open(part_log_file) = FALSE) THEN

2041: EXCEPTION
2042: WHEN JAVA_ERROR THEN
2043: raise_application_error(-20015, 'Oracle Router trucking user data generation failed');
2044: WHEN OTHERS THEN
2045: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2046: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2047: END IF;
2048: log_message(SQLERRM);
2049: utl_file.fclose(part_log_file);

Line 2046: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2042: WHEN JAVA_ERROR THEN
2043: raise_application_error(-20015, 'Oracle Router trucking user data generation failed');
2044: WHEN OTHERS THEN
2045: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2046: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2047: END IF;
2048: log_message(SQLERRM);
2049: utl_file.fclose(part_log_file);
2050: raise_application_error(-20015, 'Oracle Router trucking user data generation failed');

Line 2049: utl_file.fclose(part_log_file);

2045: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2046: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2047: END IF;
2048: log_message(SQLERRM);
2049: utl_file.fclose(part_log_file);
2050: raise_application_error(-20015, 'Oracle Router trucking user data generation failed');
2051: END create_trucking_data;
2052:
2053: --

Line 2073: utl_file.fclose(part_log_file);

2069:
2070: -- Make sure the table is actually there
2071: IF (table_exists('ROUTER_TRUCKING_DATA') = 'FALSE' ) THEN
2072: log_message('ERROR: Trucking data dump failed, ROUTER_TRUCKING_DATA table not found');
2073: utl_file.fclose(part_log_file);
2074:
2075: RAISE PARAMETER_ERROR;
2076: END IF;
2077:

Line 2089: utl_file.fclose(part_log_file);

2085:
2086: -- Validate the starting partition id.
2087: IF ((start_pid < 0) OR (start_pid > max_pid)) THEN
2088: log_message('ERROR: Invald Start Partition ID '||start_pid||', Valid Range (0,'||max_pid||')');
2089: utl_file.fclose(part_log_file);
2090:
2091: RAISE PARAMETER_ERROR;
2092: END IF;
2093:

Line 2097: utl_file.fclose(part_log_file);

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;
2101:

Line 2112: utl_file.fclose(part_log_file);

2108:
2109: log_message('', FALSE);
2110:
2111: -- Close the log file so the Java code can use it
2112: utl_file.fclose(part_log_file);
2113:
2114: elocation_dump_trucking_data(full_file_name, start_pid, l_end_pid, skip_unsupported);
2115:
2116: EXCEPTION

Line 2120: IF (utl_file.is_open(part_log_file) = FALSE) THEN

2116: EXCEPTION
2117: WHEN PARAMETER_ERROR THEN
2118: raise_application_error(-20004, 'Error, trucking data dump failed, see log file.');
2119: WHEN OTHERS THEN
2120: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2121: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2122: END IF;
2123: log_message(SQLERRM);
2124: utl_file.fclose(part_log_file);

Line 2121: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2117: WHEN PARAMETER_ERROR THEN
2118: raise_application_error(-20004, 'Error, trucking data dump failed, see log file.');
2119: WHEN OTHERS THEN
2120: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2121: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2122: END IF;
2123: log_message(SQLERRM);
2124: utl_file.fclose(part_log_file);
2125: raise_application_error(-20004, 'Error, trucking data dump failed, see log file.');

Line 2124: utl_file.fclose(part_log_file);

2120: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2121: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2122: END IF;
2123: log_message(SQLERRM);
2124: utl_file.fclose(part_log_file);
2125: raise_application_error(-20004, 'Error, trucking data dump failed, see log file.');
2126: END dump_trucking_data;
2127:
2128: ---

Line 2216: utl_file.fclose(part_log_file);

2212:
2213: EXECUTE IMMEDIATE stmt;
2214:
2215: -- Close the log file so the Java code can use it
2216: utl_file.fclose(part_log_file);
2217:
2218: -- Adjust the Oracle JVM maximum memory size to 800M.
2219: -- This is the equivelent to specifying -Xmx800m to
2220: -- java outside the database. Memory size is specified in bytes.

Line 2228: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2224: -- Java code to partition the restricted driving maneuver data
2225: elocation_turn_restrict_data(full_file_name);
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2229: log_message(SQLERRM);
2230: utl_file.fclose(part_log_file);
2231: RAISE JAVA_ERROR;
2232: END;

Line 2230: utl_file.fclose(part_log_file);

2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2229: log_message(SQLERRM);
2230: utl_file.fclose(part_log_file);
2231: RAISE JAVA_ERROR;
2232: END;
2233:
2234: -- Reopen the logfile

Line 2235: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2231: RAISE JAVA_ERROR;
2232: END;
2233:
2234: -- Reopen the logfile
2235: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2236:
2237: log_message('INFO: creating the final turn restriction user data table');
2238:
2239: -- Rename the new partition table and build an index on it.

Line 2266: utl_file.fclose(part_log_file);

2262:
2263: log_message('******** Completed generation of turn restriction user data ');
2264:
2265: -- Close the log file
2266: utl_file.fclose(part_log_file);
2267: EXCEPTION
2268: WHEN JAVA_ERROR THEN
2269: raise_application_error(-20015, 'Oracle Router turn restriction user data generation failed');
2270: WHEN OTHERS THEN

Line 2271: IF (utl_file.is_open(part_log_file) = FALSE) THEN

2267: EXCEPTION
2268: WHEN JAVA_ERROR THEN
2269: raise_application_error(-20015, 'Oracle Router turn restriction user data generation failed');
2270: WHEN OTHERS THEN
2271: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2272: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2273: END IF;
2274: log_message(SQLERRM);
2275: utl_file.fclose(part_log_file);

Line 2272: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2268: WHEN JAVA_ERROR THEN
2269: raise_application_error(-20015, 'Oracle Router turn restriction user data generation failed');
2270: WHEN OTHERS THEN
2271: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2272: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2273: END IF;
2274: log_message(SQLERRM);
2275: utl_file.fclose(part_log_file);
2276: raise_application_error(-20015, 'Oracle Router turn restriction user data generation failed');

Line 2275: utl_file.fclose(part_log_file);

2271: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2272: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2273: END IF;
2274: log_message(SQLERRM);
2275: utl_file.fclose(part_log_file);
2276: raise_application_error(-20015, 'Oracle Router turn restriction user data generation failed');
2277: END create_turn_restriction_data;
2278:
2279: --

Line 2299: utl_file.fclose(part_log_file);

2295:
2296: -- Make sure the table is actually there
2297: IF (table_exists('ROUTER_TURN_RESTRICTION_DATA') = 'FALSE' ) THEN
2298: log_message('ERROR: Turn restriction dump failed, ROUTER_TURN_RESTRICTION_DATA table not found');
2299: utl_file.fclose(part_log_file);
2300:
2301: RAISE PARAMETER_ERROR;
2302: END IF;
2303:

Line 2315: utl_file.fclose(part_log_file);

2311:
2312: -- Validate the starting partition id.
2313: IF ((start_pid < 0) OR (start_pid > max_pid)) THEN
2314: log_message('ERROR: Invald Start Partition ID '||start_pid||', Valid Range (0,'||max_pid||')');
2315: utl_file.fclose(part_log_file);
2316:
2317: RAISE PARAMETER_ERROR;
2318: END IF;
2319:

Line 2323: utl_file.fclose(part_log_file);

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;
2327:

Line 2343: utl_file.fclose(part_log_file);

2339:
2340: log_message('', FALSE);
2341:
2342: -- Close the log file so the Java code can use it
2343: utl_file.fclose(part_log_file);
2344:
2345: elocation_dump_turn_restrict(full_file_name, start_pid, l_end_pid, dump_soft_restrictions);
2346:
2347: EXCEPTION

Line 2351: IF (utl_file.is_open(part_log_file) = FALSE) THEN

2347: EXCEPTION
2348: WHEN PARAMETER_ERROR THEN
2349: raise_application_error(-20004, 'Error, turn restrictions dump failed, see log file.');
2350: WHEN OTHERS THEN
2351: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2352: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2353: END IF;
2354: log_message(SQLERRM);
2355: utl_file.fclose(part_log_file);

Line 2352: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');

2348: WHEN PARAMETER_ERROR THEN
2349: raise_application_error(-20004, 'Error, turn restrictions dump failed, see log file.');
2350: WHEN OTHERS THEN
2351: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2352: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2353: END IF;
2354: log_message(SQLERRM);
2355: utl_file.fclose(part_log_file);
2356: raise_application_error(-20004, 'Error, turn restriction dump failed, see log file.');

Line 2355: utl_file.fclose(part_log_file);

2351: IF (utl_file.is_open(part_log_file) = FALSE) THEN
2352: part_log_file := utl_file.fopen ('SDO_ROUTER_LOG_DIR', log_file_name, 'A');
2353: END IF;
2354: log_message(SQLERRM);
2355: utl_file.fclose(part_log_file);
2356: raise_application_error(-20004, 'Error, turn restriction dump failed, see log file.');
2357: END dump_turn_restriction_data;
2358:
2359: --

Line 2384: utl_file.fclose(part_log_file);

2380:
2381: dbms_output.put_line('Routeserver: data version '|| data_version);
2382: log_message('INFO: Routeserver data version: ' || data_version);
2383:
2384: utl_file.fclose(part_log_file);
2385: END;
2386:
2387: --
2388: -- main pl/sql procedure to partition a graph with coordinate information