Re: "Cannot compile program units since this is a runtime only report".

You don't say what your platform is but, give this a go. We ran into this problem when we had plsql executing in before triggers - Reports 2.5.7.4.0 on Unix. We had set up security so that users had no default roles in the database. When the report was run from a form, the report would issue a dbms_session.set_role for a role passed in from a parameter list. The idea is that the report cannot be run unless it is invoked from within Forms. The problem we ran into was validating parameters and such in before triggers, by issuing selects from database tables. Apparently Reports checks to make sure you have access to database objects used explicitly in the report's before trigger. It turned out that if we granted select access to any tables used expicitly in the select statements before the report would run. Apparently this is fixed in Reports 3.0+

Good luck,
Bob

Sasha Froyland wrote:

> Error message reported by Report Server: "Cannot compile program units
> since this is a runtime only report".
>
> Other reports I have created run just fine. The only difference is that
> this report has around 10 program units which do select against the database
> and use cursors.
>
> Funny thing is if I open a simpler report first, run it, leave Report Server
> open, then run the complex report, the complex report will run. The complex
> report doesn’t run if you shut down the Report Server originally open by the
> previous simple report.
>
> Any ideas would be appreciated.
>
> Also, can you point me to a good on-line source of Oracle technical
> materials?
>
> Thanks in advance,
>
> Mr. Sasha Froyland
> SashaFroyland_at_rfets.gov
> SashaFroyland_at_akaMail.com
Received on Tue Jun 08 1999 - 07:31:22 CDT