ORA-29274: fixed-width multibyte character set not allowed for a URL when running Sem_apis.export_rdfview_model (Doc ID 1955189.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms