15.48 SEM_APIS.CREATE_SPARQL_UPDATE_TABLES
Format
SEM_APIS.CREATE_SPARQL_UPDATE_TABLES();
Description
Creates global temporary tables in the caller’s schema for use with SPARQL Update operations.
Parameters
None.
Usage Notes
Invoking SEM_APIS.UPDATE_MODEL with
STREAMING=F
, FORCE_BULK=T
, or
DEL_AS_INS=T
option requires that the following temporary tables exist in
the caller’s schema: RDF_UPD_DEL$, RDF_UPD_INS$, and RDF_UPD_INS_CLOB$. These tables are
created with the following definitions , where MAX_STRING_SIZE
is the
maximum VARCHAR size for the database:
CREATE GLOBAL TEMPORARY TABLE RDF_UPD_DEL$ (
RDF$STC_GRAPH VARCHAR2(4000),
RDF$STC_SUB VARCHAR2(4000),
RDF$STC_PRED VARCHAR2(4000),
RDF$STC_OBJ VARCHAR2(MAX_STRING_SIZE),
RDF$STC_CLOB CLOB
) ON COMMIT PRESERVE ROWS';
CREATE GLOBAL TEMPORARY TABLE RDF_UPD_INS$ (
RDF$STC_GRAPH VARCHAR2(4000),
RDF$STC_SUB VARCHAR2(4000),
RDF$STC_PRED VARCHAR2(4000),
RDF$STC_OBJ VARCHAR2(MAX_STRING_SIZE)
) ON COMMIT PRESERVE ROWS';
CREATE GLOBAL TEMPORARY TABLE RDF_UPD_INS_CLOB$ (
RDF$STC_GRAPH VARCHAR2(4000),
RDF$STC_SUB VARCHAR2(4000),
RDF$STC_PRED VARCHAR2(4000),
RDF$STC_OBJ VARCHAR2(MAX_STRING_SIZE),
RDF$STC_CLOB CLOB
) ON COMMIT PRESERVE ROWS';
If you need to drop these tables, use the SEM_APIS.DROP_SPARQL_UPDATE_TABLES.
For more information, see Support for SPARQL Update Operations on an RDF Graph.
Examples
The following example creates the necessary global temporary tables in the caller’s schema for use with SPARQL Update operations.
EXECUTE SEM_APIS.CREATE_SPARQL_UPDATE_TABLES;
Parent topic: SEM_APIS Package Subprograms