Re: Oracle Reports 3.x

From: Patrick Flahan <flahan_at_earthlink.net>
Date: Mon, 5 Apr 1999 12:55:42 -0400
Message-ID: <7eaq4l$d8a$1_at_birch.prod.itd.earthlink.net>


You could create a package specification in the Program Units section of the Report. You don't have to have a body or any procedures/functions defined for the package. You should be able to access and set any of the variables that you define in the spec from almost anywhere in the report triggers or other program units.

You could define something like the package below and reference the variables by using the <package>.<object> notation (i.e. Rpt_Pkg.cMyChar or Rpt_Pkg.nMyNum)

PACKAGE Rpt_Pkg
IS
  cMyChar VARCHAR2(30);
  nMyNum NUMBER;

END Rpt_Pkg;

Hope this helps,
Patrick Flahan
flahan_at_earthlink.net

Don Miller <dmiller_at_nsf.org> wrote in message news:3708c71a.0_at_news.ic.net...
> Can anyone tell me how to create a global variable in Reports 3.x with out
> using a parameter field.
>
> Don
> dmiller_at_nsf.org
>
>
Received on Mon Apr 05 1999 - 18:55:42 CEST

Original text of this message