Re: Plez help with RUN_PRODUCT or RUN_REPORT_OBJECT

I ran into this problem a while back. You have two choices 1.) Create a parameter list and pass it to the run_product 2.) Declare a variable before the call to run_product and populate it to a null. Then call run_product and then pass the variable name to run_product. This happen to me when Oracle changed from 4.5 to 5. Good Luck,
Keith Lowdon klowdon_at_mts.net

"Richard Hollingsworth" <william.hollingsworth_at_hsv.boeing.com> wrote in message news:3A018F06.3D149760_at_hsv.boeing.com...
> Hi:
>
> I'm trying to run a 6i report from a forms 6 button.
>
> I was told to use the RUN_PRODUCT(REPORTS,...) build-in. When I use the
> command....(right out of Lulushi's book)
>
> RUN_PRODUCT(REPORTS, 'c:\6i_home\sil\allcrs', SYNCHRONOUS, RUNTIME,
> FILESYSTEM,NULL,NULL);
>
> .....I get....."Too many declarations of this call" .....at compile
> time.
>
> But this is the ONLY one I have!
>
> Now, if I try the RUN_REPORTS command....... (right out of the HELP
> file)
> DECLARE
> repid REPORT_OBJECT;
> v_rep VARCHAR2(100);
> rep_status varchar2(20);
> BEGIN
> repid := find_report_object('c:\6i_home\sil\allcrs.rep');
> v_rep := RUN_REPORT_OBJECT(repid);
> END;
>
> ......I get......."Can't find this onject" at runtime.
>
> Does anyone have a specific example of how to use either of these
> commands?
>
> This is really frustrating.
>
> Thanks,
> Richard Hollingsworth
>
Received on Sat Nov 04 2000 - 18:44:59 CET