Re: [cx-oracle-users] cx_Oracle cannot parse this convoluted SQL statement
Brought to you by:
atuining
From: Henning v. B. <H.v...@t-...> - 2006-12-07 17:35:32
|
Peter Masiar asked: > ... > SQL statement: SELECT x neuron FROM TABLE(SDO_RDF_MATCH( '(?x r:type c:neuron)', SDO_RDF_Models('senselab3'), SDO_RDF_Rulebases('RDFS','senselab3_rb'), SDO_RDF_Aliases(SDO_RDF_Alias('c','http://senselab.med.yale.edu/class#') , SDO_RDF_Alias('i','http://senselab.med.yale.edu/instance#'), SDO_RDF_Alias('r','http://www.w3.org/1999/02/22-rdf-syntax-ns#') ), null)); > ... > DatabaseError: ORA-00911: invalid character Peter, you should not use the semicolon, it is not part of SQL, but rather it is used in SQL*Plus and PL/SQL to delimit statement. Try without it. HtH Henning |