6.38 SDO_NET.GENERATE_PARTITION_BLOB
Format
SDO_NET.GENERATE_PARTITION_BLOB( network IN VARCHAR2, link_level IN NUMBER DEFAULT 1, partition_id IN VARCHAR2, include_user_data IN BOOLEAN, log_loc IN VARCHAR2, log_file IN VARCHAR2, open_mode IN VARCHAR2 DEFAULT 'A', preform_delta_update IN BOOLEAN DEFAULT FALSE);
Description
Generates a single binary large object (BLOB) representation for a specified partition associated with a specified link level in the network, and stores the information in the existing partition BLOB table.
Parameters
- network
-
Network name.
- link_level
-
Link level for links to be included in the BLOB (default = 1). The link level reflects the priority level for the link, and is used for network analysis, so that links with higher priority levels can be considered first in computing a path.
- partition_id
-
Partition ID number. Network elements associated with the specified combination of link level and partition ID are included in the generated BLOB.
- include_user_data
-
TRUE
if the BLOB should include any user data of category 0 (zero) associated with the network elements represented in each BLOB, orFALSE
if the BLOB should not include any user data. - log_loc
-
Directory object that identifies the path for the log file. To create a directory object, use the SQL*Plus command CREATE DIRECTORY.
- log_file
-
Log file containing information about spatial network operations, including any possible errors or problems.
- open_mode
-
A one-character code indicating the mode in which to open the log file:
W
for write over (that is, delete any existing log file at the specified location and name, and create a new file), orA
(the default) for append (that is, append information to the existing specified log file). If you specifyA
and the log file does not exist, a new log file is created. - perform_delta_update
-
(Reserved for future use. The only permitted value is
FALSE
, the default.)
Usage Notes
This procedure adds a single new BLOB or replaces a single existing BLOB in the partition BLOB table, which must have been previously created using the SDO_NET.GENERATE_PARTITION_BLOBS procedure.
One use for this procedure is to perform a relatively quick update of the BLOB for a desired partition in a network that contains multiple large partitions, as opposed to than updating the BLOBs for all partitions using the SDO_NET.GENERATE_PARTITION_BLOBS procedure.
Examples
The following example generates the partition BLOB for the partition associated with partition ID 1 and link level 1 in the SDO_PARTITIONED network, and adds or replaces the appropriate BLOB in the SDO_PARTITIONED_PART_BLOB_TAB table. Any user data of category 0 (zero) associated with the network elements is also included. Information about the operation is added (open_mode => 'a'
) to the sdo_partitioned.log
file, located in the location associated with the directory object named LOG_DIR
.
EXECUTE SDO_NET.GENERATE_PARTITION_BLOB(- network => 'SDO_PARTITIONED', - link_level => 1,- partition_id => 1,- include_user_data => true,- log_loc => 'LOG_DIR', log_file=> 'sdo_partitioned.log',- open_mode => 'a');
Parent topic: SDO_NET Package Subprograms