This section discusses the use of XML files related to distribution:
When you create a distribution XML file, you follow the syntax defined in the
distribution.dtd file located in the following directory on both Windows and UNIX:
As you look through the following sections, it may be useful to you to print the
distribution.dtd file and refer to it as you review the descriptions of the elements and attributes.
Information provided in the distribution XML file is case-sensitive. You must preserve case of various elements and attributes as specified in the
distribution.dtd file lists all elements that are valid within a distribution XML file. Each of these elements have attributes. Attributes that come with default values need not be specified, unless you wish to override the default.
You can create a dynamic distribution by introducing variable values into many different attributes. Variable values reference columns that are present in the report that is using the distribution XML file.
The ampersand (
&) and less-than symbol (
<) have specific meanings in XML, but they are also required symbols for certain Oracle Reports command line options (for example, lexical parameters require the ampersand symbol). To avoid conflict with the XML meanings of these symbols when you set up variables, specify the encoded version of the ampersand (
&) and less-than and greater-than symbols (
>). For example:
Here is what the variable looks like improperly coded in an XML file:
<mail id="a1" to="&<manager>@mycompany.com" …
Here is what the variable looks like properly coded in an XML file:
<mail id="a1" to="&<manager>@mycompany.com" …>
There is no special requirement for the greater-than symbol (>) used with variables, but for consistency, we recommend that you use the encoded version (
The variable syntax you use depends on whether the value is expressed by itself or in combination with other values or strings. For example, a value for a
to attribute in a mail element might be expressed as either:
<mail id="a2" to="&email" …>
<mail id="a3" to="&<first_name>.&<last_name>@myco.com …>
In the first example (
id="a2"), the variable's referenced column (
id="a3") uses a combination of variable values (
last_name) and static text to construct an e-mail address (static text is the period after
@myco.com). In both cases, you will get dynamic e-mail addressing. The example you use will depend on whether the variable contains all the information you need or requires additional information in order to be complete.
PL/SQL formula CF_MAILID: return(:first_name||'.'||:last_name)
You'd reference this column in the distribution XML file as: