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

    Create a RDF view model with R2RML on a CLOB column

    jhidding

      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.