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

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;