1 Reply Latest reply on Mar 19, 2007 3:58 AM by Mannamal-Oracle

    Problem in Select Query..Missing Key word

    502844
      Hello,
      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


      Please help!!!

      Thanks

      Regards

      Prateek
        • 1. Re: Problem in Select Query..Missing Key word
          Mannamal-Oracle
          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.

          Melli