22.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 22-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;