Compiling a New Aggregate

Once the user has defined the aggregate using SQL-AG, he/she can call the pre-compiler to generate the following stored PL/SQL procedure :

Therefore the user calls the pre-compiler Aggregate on the file filename.spec. The pre-compiler uses a file text.sql that contains aggregate independent code to generate the procedure in a file generated.sql. The user gives the following command :

Here filename.spec contains the specification of the aggregate.
The Pre-compiler accepts a program written in SQL-AG and collects the following information:

• name of the aggregate,
• argument list for the procedure Output,
• type declaration of internalrecord type,
• definitions of the procedures Single, Multi and Produce,
• code of other subprograms defined by user.