SQL Errors
When a SQL script is run or validated in Reports Wand, the SQL execution will fail if the SQL is invalid.
One of the possible causes of SQL failing is that the SQL script is a legacy script from Reports Wand v4. The format of SQL bind parameters is different in Reports Wand v5. The SQL will need to be updated to work correctly in Reports Wand v5.
It is recommended that SQL is first developed in a SQL editor such as TOAD or SQL Developer.
Reports Wand will display the Oracle SQL error message in the dialog to help identify why the SQL has failed. These SQL error messages are the same messages that would be displayed in a SQL editor such as TOAD or SQL Developer.
For example, this script will fail when being executed or validated:
SELECT name FROM gl_ledger WHERE name = :NAME
This will fail as the table gl_ledger doesn’t exist.