title: ORA-06550 when trying to check if a table exists
body: <p>I'd like to check weather a table exists before creating one, in an Oracle database.
  Though, the following statement is not working throwing error ORA-06550 on line 7 (CREATE).</p>
  
  <pre><code>  DECLARE cnt NUMBER;
    BEGIN
      SELECT COUNT(*) INTO cnt FROM ALL_TABLES WHERE lower(table_name) = lower('TestTable');
  
      IF( cnt = 0 )
      THEN
        CREATE TABLE TestTable
        (
          TestFlag NUMBER(1) NOT NULL
        );
      END IF;
    END;
  </code></pre>
  
  <p>Can anyone help me out with this one?</p>
  
  <p>Thanks in advance!</p>