Using Oracle Reports PL/SQL Package SRW
- Using Oracle Reports PL/SQL Package SRW
The Oracle Reports PL/SQL Package: SRW
To save you time, Oracle Reports is shipped with a package--i.e., a collection of PL/SQL constructs--that contains many functions, procedures, and exceptions you can reference in any of your libraries or reports. The name of Oracle Reports' package is SRW. As a result, any time you reference a construct in the SRW package, you must prefix it with SRW, for example, SRW.SET_ATTR.
SRW.SET_ATTR applies attibute settings such as font size or color to layout objects.Type: Procedure Syntax:SRW.SET_ATTR (object_id NUMBER, attr SRW.GENERIC_ATTR);Description:This procedure applies formatting attributes to the current frame, repeating frame, field, or boilerplate object. You specify which formatting attributes should be applied to an object by defining a mask. A mask is a collection of attributes; each attribute has one or more values. You create a mask much like you would create a mask for a masquerade party:
first you specify the attributes of the mask (e.g., eyes), then you 'set the value' of each attribute (e.g., brown). To define and then apply a mask in PL/SQL, you do the following:
- Specify the mask's attributes you wish to set (e.g., the border). Specify a value for each attribute that you specified (e.g., width of 1 character). Apply the mask to the object by calling the SRW.SET_ATTR procedure.
Below is an example of specifying two attributes (and their values) for the mask: SRW.ATTR.MASK := SRW.BORDERWIDTH_ATTR + -- attribute SRW.FILLPATT_ATTR; -- attribute SRW.ATTR.BORDERWIDTH := 1; -- value for attribute SRW.ATTR.FILLPATT := 'SOLID';-- value for attribute SRW.SET_ATTR(0, SRW.ATTR)Problems
- Need help with Reports