I have the exact same problem as the one described in this OTM thread: Create a RDF view model with R2RML on a CLOB column
I try to map a point in a relational view to RDF (I tried both SDO_GEOMETRY and CLOB as column datatype). I encounter the same error as in the other thread (typecode = 109 or 112 depending on the column datatype being a sdo_geometry or o clob)
BEGIN sem_apis.create_rdfview_model( model_name => 'mymodel', tables => NULL, r2rml_table_owner => 'MYUSER', r2rml_table_name => 'STAGE_TABLE'); END;
DBD::Oracle::st execute failed: ORA-13199: Incompatible types:
Database Column (COLUMN_LATLONG_POINT) 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: at "MDSYS.SDO_RDF_INTERNAL", line 13806
ORA-06512: at "MDSYS.SDO_RDF", line 3776
ORA-06512: at "MDSYS.SDO_RDF", line 3849
ORA-06512: at "MDSYS.RDF_APIS", line 1276
Can someone tell me what I'm doing wrong?
We have a patch for 188.8.131.52 that supports CLOB and SDO_GEOMETRY.
Please submit a Service Request (SR) to get access to this patch.