Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: call reports from a form

Re: call reports from a form

From: YAN SUN <ysun_at_ENGIN.UMICH.EDU>
Date: Mon, 4 Mar 1996 12:11:58 -0500
Message-Id: <9603041730.AA23719@alice.jcc.com>


Paul:
here is the code:
declare

        plid Paramlist;

begin

    if (:bl_hardware.barcode is not null) then

        plid :=
             create_parameter_list('machine_params');
        add_parameter(plid, 'BARCODE_PARAM', TEXT_PARAMETER,
                :bl_hardware.barcode);
        add_parameter(plid, 'DESTYPE', TEXT_PARAMETER, 'PREVIEW');

        run_product (REPORTS,'machine.rep', SYNCHRONOUS,
                        RUNTIME, FILESYSTEM, plid);

        destroy_parameter_list(plid);
    else
        message('Report cannot be generated without a barcode');
        raise form_trigger_failure;

    end if;
end;

same kinda of error message i get even with "NULL", it seems like it needs paramform set somehow in the form.

thanks,

-yan
. Received on Mon Mar 04 1996 - 12:30:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US