21.28 VALIDATE_INSTANCE_SETTING Procedure

This procedure validates appropriate instance settings (table, column, generation level).

Syntax

APEX_DG_DATA_GEN.VALIDATE_INSTANCE_SETTING (
    p_json      IN          CLOB,
    p_valid     OUT NOCOPY  VARCHAR2,
    p_message   OUT NOCOPY  CLOB )

Parameters

Table 21-28 VALIDATE_INSTANCE_SETTING Parameters

Parameter	Description
p_json	JSON Document.
p_valid	Out parameter to identify whether settings are valid.
p_result	Out parameter with a detailed message.

Example

DECLARE
    l_is_valid varchar2(30);
    l_message clob;
BEGIN
   apex_dg_data_gen.validate_instance_setting(
                p_json               => '<json_doc>',
                p_valid              => l_is_valid,
                p_message            => l_message);
END;