Re: Calling REPORT (with PL/SQL) from FORM4.5

DanHW wrote:
>
> We have the same situation - calling a report that needs to have roles set
> before it reports anything. What we do is in the BEFORE-PARAMETER-FORM trigger,
> set the appropriate roles. We have lots of PL/SQL in the report, and all works
> fine. We also only give the users the RPT version of the form, generated by a
> user with default access to the tables. The users do not get run the REP
> version.
>

Hallo,

[Quoted] I'm also using the BEFORE-PARAMETER-FORM trigger to set the role, nevertheless I have problems with a CF-Field (Column-Field). In the trigger of this field I also set the role and I want to execute a select - statement to get additional informations. The select based on a field (it is part of the where-clause) that is a part of another reports-query and the select should only be executed if this field is not null. So I want to emulate an outer join.

When the report (*.rdf - File) runs for the first time a compilation error occur "...there is no compiled pl/sql". It seems like not enouth permissions for the user. The second run of report works fine and the only one difference to the first is that the reports server is running. What's wrong?

Regards,

Sigrid Received on Sun Apr 19 1998 - 00:00:00 CEST