ORA-32035: unreferenced query name defined in WITH clause

[xlnt]

All our reports are failing with the above error.

Database used is Oracle 10G.

If I set the 'Use SQL With Clause' option to 'No', the reports start working fine.

Please can somebody help with this:

1. Why all reports are failing with this error (approx 30 reports)
2. Instead of changing the value of the above property to 'No' for each query in all these reports - can I change it at a global level?

[MFGF]

Hi,

It can be set in Framework Manager - Project -> Edit Governors if memory serves.

You would then need to re-publish your package(s).

MF.