Dear all,
I'm trying to materialize the triples from a virtual model using the function sem_apis.export_rdfview_model as follow:
BEGIN
sem_apis.export_rdfview_model(
model_name => 'MODEL_VIRTUAL',
rdf_table_owner => 'MyUser',
rdf_table_name => 'STAGE_TABLE');
END;
But, the function returns the error below:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "MDSYS.SDO_RDF", line 451
ORA-06512: at "MDSYS.SDO_RDF", line 15876
ORA-06512: at line 1
ORA-06512: at "MDSYS.SDO_RDF", line 5420
ORA-06512: at "MDSYS.SDO_RDF", line 5709
ORA-06512: at "MDSYS.SDO_RDF", line 5761
ORA-06512: at "MDSYS.RDF_APIS", line 1358
ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN
sem_apis.export_rdfview_model(
model_name => 'MODEL_VIRTUAL',
rdf_table_owner => 'MyUser',
rdf_table_name => 'STAGE_TABLE');
The virtual model was created via a set of R2RML maps, and the source table has the following structure:
TABLE PERSON_INFO(
ID NUMBER(10,0) NOT NULL ENABLE,
INFO_TYPE_ID NUMBER(10,0) NOT NULL ENABLE,
PERSON_ID NUMBER(10,0) NOT NULL ENABLE,
INFO VARCHAR2(4000 BYTE),
INFO_TYPE VARCHAR2(288 BYTE),
META_REPCOL VARCHAR2(4000 BYTE) NOT NULL ENABLE,
CONSTRAINT "PERSON_INFO_PK" PRIMARY KEY ("ID")
);
Moreover, the STAGE_TABLE was created as mentioned in Oracle Documentation.
Someone help me, please.
Thank you in advance,
Yenier