21.16 PREVIEW_BLUEPRINT Procedure

This procedure creates preview data for a blueprint and stores this in APEX collections. This procedure can only be used with an active APEX session.

Syntax

APEX_DG_DATA_GEN.PREVIEW_BLUEPRINT (
  parameter_1 IN NUMBER,
  parameter_2 IN VARCHAR2,
  parameter_3 IN NUMBER )

Parameters

Table 21-16 PREVIEW_BLUEPRINT Parameters

Parameter Description
p_blueprint Name of the blueprint.
p_table_name

If null, all tables.

If not null, the specified table.

p_number_of_rows Number of rows to generate (maximum of 50).
p_data_collection Name of the APEX collection for data.
p_header_collection Name of the APEX collection for headers.

Example

BEGIN
    apex_dg_output.preview_blueprint
        (p_blueprint          => 'Cars',
         p_table_name         => 'my_cars',
         p_data_collection    => 'CARS_DATA',
         p_header_collection  => 'CARS_HEADERS'
        );
END;