Can someone please point the error in this query,
execute immediate 'SELECT t.triple.rdf_t_id INTO RDF_triple_id from timestamp_rdf_data t WHERE t.triple.GET_PROPERTY()='||''''||temp.predicate||'''';--||'AND t.triple.GET_SUBJECT()='||''''||temp.subject||''''|| 'AND dbms_lob.substr(t.triple.GET_OBJECT()) ='||''''||temp.object||'''' ; ;
It gives me error
ERROR at line 1:
ORA-00905: missing keyword
ORA-06512: at "SCOTT.REIFICATION", line 127
ORA-06512: at line 1
There seems to be some characters in the SQL string - ";--" which would raise an error. I am not sure whether that was just at typo when you cut-paste the statement on this forum.
One way to debug this is to try simple SQL query first, with some sample constants for temp.predicate, temp.subject etc. Once that works you can try the 'execute immediate' statement. The quotes can get confusing as well - was your intent to use double quotes to enclose the predicate, subject, object values? Try single quotes.