Home › Discussions › Questions & Answers › Regarding Blitz Report SQL Validation

Regarding Blitz Report SQL Validation

Avatar photoCustomer Questions & Answers 2 replies

Hi,

I need your suggestion on attached list of validation report, these report are listed in Error list however they completes in success/Normal.

 

“ORA-00936: missing expression ORA-06512: at “”SYS.DBMS_SQL””, line 1199″

“ORA-01741: illegal zero-length identifier ORA-06512: at “”SYS.DBMS_SQL””, line 1199″

What could be the reason of getting listed in error list?

2 replies

  • Support Enginatics

    Hi,

    These errors can be ignored if the report works correctly when running it separately.

    The reason for the errors is that these reports use &lexical parameters to compose dynamic SQL, and the value for these lexicals depend on parameter values, which would be entered by the user at runtime.
    When the Blitz Report SQL Validation report runs however, it cannot correctly replace these lexicals, as it doesn’t have the user entered parameter values, for example:

    Regards,
    Andy

  • Hi Andy,

    Even I thought same however thought of checking with you just before ignoring these errors.

    Thank you for looking in to it.

  • You must be logged in to reply to this post.