PL/SQL-Block

Initial PL/SQL execution block

An optional PL/SQL Block that is executed before the report data is fetched.

Syntax:

PL/SQL-Block{
<PlsqlStatement>
}

Typical usage is to set condition variables or top level report attributes.

PL/SQL-Block {
   BEGIN
      :ActorBiography := (:ActorCount > 0);
   END;
}

Note:   Must begin with the word 'DEFINE' or 'BEGIN' and end with 'END;'.

This page is generated from IFS Developer Studio at 2025-03-23 11:20.