24.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
| 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;Parent topic: APEX_DG_DATA_GEN