Created by Alex Chard on Apr 15, 2014

When a SQL script is run or validated in Reports Wand, the SQL execution will fail if the SQL is invalid.

Icon

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.

Icon

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.

Attachments:

e4awand_32_edit_drill_template_layout.png (image/png)
Untitled-22.jpg (image/jpeg)