ORA-00933 SQL command not properly ended

Resolving The Problem

1. If you are using type-in SQL with date prompts you may also receive this error:
ORA-01858, non-numeric character was found where a numeric was expected.

See Impromptu Release Notes/ Known Problem Areas/ Database Enigmas/ Type-in SQL

Using Date Prompts in Edited SQL
You can place a date prompt in the SQL tab SQL Query dialog box. However, we recommend against the use of date prompts in manually entered SQL because of the generation of SQL92 typed literals. For example, in the following SQL, the prompt ?date? can result in an invalid query to the database

select T1."Course, T1."Assignnum", T1."Weighting", T1."Description", T1."Date Due" from "admin"."Assignment" T1 where T1."Date Due"<?date?

Instead, we recommend that you use string prompts and enter date literals in the database-specific format.

select T1."Course", T1."Assignnum", T1."Weighting", T1."Description", T1."Date Due" from "admin"."Assignment" T1 where T1."Date Due"<?string?

However, you must enter the correct format for your database, since DATE and DATETIME formats differ from database to database.

2. There was a problem in earlier versions of Impromptu when attempting to create a query that joined Oracle tables and hotfiles. This has since been fixed and if you are using a version of Impromptu prior to 3.04, the latest version of Impromptu should be obtained.

3. Make sure that you have not renamed tables in the catalog at the Catalog/Tables - Edit level. Any renaming that needs to be done in order to make table or column names more meaningful should be done at the Catalog/Folder level. Catalog tables should only be renamed at the Catalog/Table level if the table names have changed in the database.