0 Replies Latest reply on Feb 1, 2016 2:40 PM by jhidding

    Create a RDF view model with R2RML on a CLOB column


      I want to create a RDF view model on a table with a database column GEOWKT_LATLONG. This column is of type CLOB.

      I use the prefix

      @prefix orageo: <http://xmlns.oracle.com/rdf/geo/> .

      @prefix rr: <http://www.w3.org/ns/r2rml#>.


      and the mapping is

      rr:predicateObjectMap [

              rr:predicate geosparql:hasGeometry;

              rr:objectMap [ rr:column "GEOWKT_LATLONG"; rr:datatype orageo:WKTLiteral ]



      when I run the statement "sem_apis.create_rdfview_model", I get the following error message:

      Error report -

      ORA-13199: Incompatible types:

      Database Column (GEOWKT_LATLONG) typecode = 112 ((UNSUPPORTED DBMS_TYPES TYPECODE: 112)(0,0))

      R2RML mapping specified type = <http://xmlns.oracle.com/rdf/geo/WKTLiteral>

      ideal RDF datatype: UNKNOWN


      ORA-06512: in "MDSYS.SDO_RDF_INTERNAL", regel 13806




      ORA-06512: in "MDSYS.SDO_RDF", regel 3776

      ORA-06512: in "MDSYS.SDO_RDF", regel 3849

      ORA-06512: in "MDSYS.RDF_APIS", regel 1276

      ORA-06512: in regel 2

      13199. 00000 -  "%s"

      *Cause:    This is an internal error.

      *Action:   Contact Oracle Support Services.


      Is there someone to help me to solve this problem.