Re: "RUNNING ORACLE REPORT FROM FORMS"

Thomas Morgan wrote:
> In our office we are just beginning to integrate oracle forms and reports.
> We have this one report that we just call from a menu item. If I am running
> the form with the account of the designer of the report, the report runs
> fine, if however we run the form (and the report for that matter) using a
> ROLE that has all the right permissions then reports does not seem to want
> to run any PL/SQL statement. For instance if we have record on a table and
> we simply select them for display then they will display fine. If however I
> perform a simple delete from the table in the before report trigger then I
> get this message:
>
> Starting report CWS_JOB_POSTING [Wed Jun 09 15:42:19 1999] ...
> REP-1439: Cannot compile program units since this is a runtime only report.
> End report CWS_JOB_POSTING [Wed Jun 09 15:42:27 1999].

Hrm, you have to see how you are using the pl/sql command that spawns oracle reports, you know there are several commands that you issue and heir arguments: look at the procedure RUN_PRODUCT and see it's args. One of them is batch vs. runtime, set it to batch... and dont forget the null (if applicable) as the last column... I didnt use the last arg and assumed that it assigned a default... SHEESH, how wrong was I!!

ciao, elmo

--

Elmo Recio; Philadelphia, PA 19103; USA
Homepage: http://polywog.navpoint.com/~elmo
Sociology/Philosophy student at Drexel Univ

Oracle Applications Development at OIT_at_TJU
Linux Project Co-ordinator at OIT_at_TJU

"SO NOW I'M ALONE 
 AND I CAN THINK FOR MYSELF 
 ABOUT LITTLE DEALS AND S.U.'s 
 AND THINGS I JUST DON'T UNDERSTAND 
 LIKE A WHITE LIE THAT NIGHT 
 OR A SLY TOUCH AT TIMES 
 I DON'T THINK IT MEANT ANYTHING TO YOU"
-INSOC (Are Friends Electric)