19.1 ADD_BLUEPRINT Procedure

This procedure creates a blueprint which is a collection of tables with corresponding columns and data generation attributes.

Syntax

APEX_DG_DATA_GEN.ADD_BLUEPRINT (
    p_name                  IN VARCHAR2,
    p_display_name          IN VARCHAR2 DEFAULT NULL,
    p_description           IN VARCHAR2 DEFAULT NULL,
    p_lang                  IN VARCHAR2 DEFAULT 'en',
    p_default_schema        IN VARCHAR2 DEFAULT NULL,
    p_blueprint_id          OUT NUMBER )

Parameters

Table 19-1 ADD_BLUEPRINT Parameters

Parameter	Description
p_name	Identifier for the blueprint, combination of name and language is unique. Name is automatically upper cased and special characters removed.
p_display_name	Friendly display name.
p_description	Description of the blueprint.
p_lang	Blueprint language determines values from built-in data sources. If the built-in data source has 0 records in this language, en is used.
p_default_schema	The default schema name for the blueprint.
p_blueprint_id	ID of the added blueprint (OUT).

Example

DECLARE
  l_blueprint_id number;
BEGIN
    apex_dg_data_gen.add_blueprint(
                 p_name           => 'Cars',
                 p_display_name   => 'My Cars Blueprint',
                 p_description    => 'A blueprint to generate car data',
                 p_blueprint_id   => l_blueprint_id);
END;