title: Testing native dynamic SQL in Oracle before execution
body: <p>I have implemented a certain feature in my application where the user can compose queries dynamically from the user interface by pushing around buttons and inserting some values here and there.</p>
  
  <p>The user will not see the generated SQL statement at all.</p>
  
  <p>I was wondering if there is a way to perhaps check the syntax and grammar <em>(e.g. he opened a parantheses '(' and forgot to close it )</em> of the dynamically generated SQL to ensure that no <strong>run-time  compilation errors</strong> would happen before actually executing the statement using <a href="http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/executeimmediate_statement.htm" rel="nofollow">EXECUTE IMMEDIATE</a>.</p>