19.27 VALIDATE_BLUEPRINT Procedure

This procedure validates the blueprint by checking the validity of the generated SQL.

Syntax

APEX_DG_DATA_GEN.VALIDATE_BLUEPRINT (
    p_blueprint          IN     VARCHAR2,
    p_format             IN     VARCHAR2,
    p_errors             OUT    CLOB )

Parameters

Table 19-27 VALIDATE_BLUEPRINT Parameters

Parameter	Description
p_blueprint	Name of the blueprint.
p_format	CSV, SQL INSERT, JSON, PRETTY JSON, INSERT INTO, or FAST INSERT INTO.
p_errors	Clob holds error output.

Example

DECLARE
   l_errors    clob;
BEGIN
   apex_dg_output.validate_blueprint
       (p_blueprint          => 'Cars',
        p_format             => 'JSON',
        p_errors             => l_errors
       );
END;