Re: RUN_PRODUCT

Though not exactly a solution to your problem, I working on something very similar now. My Form makes an insert into a table . That table has an after-insert trigger that fires a DBMS_JOB.SUBMIT, to execute a certain procedure. Based on results of that procedure, I have to run a report. My Form checks, with a timer, a view called dba_jobs_running to check when the procedure is completed, then runs the report thru RUN_PRODUCT. Hope this helps, let me know your solution if different. Regards,
Gary

Warren Weis <ez041151_at_ucdavis.edu> wrote in article
> I'm using the procedure RUN_PRODUCT to run a report from a form. Does
> anyone know how the form can know whether the report successfully
> ran or not?
> RUN_PRODUCT is a procedure so it does not return a value.
> I had hoped that an error, such as not finding the report, would raise
> an exception in the form program object attempting the call, but this
> also does not appear to be the case.
>
> Thanks,
Received on Wed Dec 11 1996 - 00:00:00 CET