9.31 OPG_APIS.FIND_SP_PREP
Format
OPG_APIS.FIND_SP_PREP( edge_tab_name IN VARCHAR2, exp_tab IN OUT VARCHAR2, options IN VARCHAR2 DEFAULT NULL);
Description
Prepares for shortest path calculations.
Parameters
- edge_tab_name
-
Name of the property graph edge table.
- exp_tab
-
Name of the expansion table to be used for shortest path calculations. If it is empty, an intermediate working table will be created and the table name will be returned in
exp_tab
. - options
-
Additional settings for the operation. An optional string with one or more (comma-separated) of the following values:
-
CREATE_UNDIRECTED=T
-
REUSE_UNDIRECTED_TAB=T
-
Usage Notes
The property graph edge table must exist in the database.
Examples
The following example does preparation work before doing shortest path calculations in a property graph named mypg
set serveroutput on DECLARE wtExp varchar2(2000); -- name of working table for shortest path calculation BEGIN opg_apis.find_sp_prep('mypgGE$', wtExp, null); dbms_output.put_line('Working table name ' || wtExp); END; /
The output will be similar to the following. (Your output may be different depending on the SQL session ID.)
Working table name "MYPGGE$$TWFS277"
Parent topic: OPG_APIS Package Subprograms