Last updated on FEBRUARY 08, 2017

Applies to:

Symptoms

Using the R2RML method of generating semantic RDF triples in Oracle 12c

One model successfully created without any problems but then moved to a bigger one and were able to generate around 3,500 of the mapped triples into the staging table before it runs into an error when we call sem_apis.export_rdfview_model:

NLS_CHARACTERSET
----------------
WE8MSWIN1252


Error starting at line : 1 in command -

BEGIN
 sem_apis.export_rdfview_model(
  model_name => 'PLM_R2RML_TEST_MODEL',
  rdf_table_owner => 'SEMANTIC',
  rdf_table_name => 'PLM_R2RML_TEST_MODEL_TPL'
 );
END;

Error report -
ORA-29274: fixed-width multibyte character set not allowed for a URL
ORA-06512: at "SYS.UTL_URL", line 4
ORA-06512: at "SYS.UTL_URL", line 118
ORA-06512: at "MDSYS.SDO_RDF", line 319
ORA-06512: at line 1
ORA-06512: at "MDSYS.SDO_RDF", line 3133
ORA-06512: at "MDSYS.SDO_RDF", line 3411
ORA-06512: at "MDSYS.SDO_RDF", line 3466
ORA-06512: at "MDSYS.RDF_APIS", line 1239
ORA-06512: at line 2
29274. 00000 - "fixed-width multibyte character set not allowed for a URL"

*Cause: The character set used as an encoding of the URL is a fixed-width

  multibyte character set and is not allowed for a URL.

*Action: Use the corresponding variable-width multibyte character set for

  the URL instead.

Cause