I have a select statement with bind variables gathered using Oracle tooling while running a package via a Java Web application. I can run the SQL in Toad using the “Execute/Compile statement at caret” command, setting the variables. Here is the SQL:
(NOTE: I turned off “Refactor SQL before optimizing,” and that got rid of a very unhelpful “Exception was thrown” error.)
When I try to run the same SQL using the “Auto-optimize SQL at caret using re-writes”, I get this error message: “ORA-00905: missing keyword”
Is there any way I could get more detail on where this mysterious error is in the statement? I tried running it in SQL*Plus, but it works there.
Thanks in advance for any help you could offer.
Toad 32-bit 22.214.171.124