Oracle Distributed Systems

Name

DBMS_REPCAT.VALIDATE

Synopsis

The VALIDATE function diagnoses the status of your replicated environment and returns any errors in either a PL/SQL array of records (error_table) or a pair of arrays with error text (error_msg_table) and error numbers (error_num_table).

FUNCTION validate(gname             IN  VARCHAR2,
                  check_genflags    IN  BOOLEAN := FALSE,
                  check_valid_objs  IN  BOOLEAN := FALSE,
                  check_links_sched IN  BOOLEAN := FALSE,
                  check_links       IN  BOOLEAN := FALSE,
                  error_table       OUT dbms_repcat.validate_err_table)

FUNCTION validate(gname             IN  VARCHAR2,
                  check_genflags    IN  BOOLEAN := FALSE,
                  check_valid_objs  IN  BOOLEAN := FALSE,
                  check_links_sched IN  BOOLEAN := FALSE,
                  check_links       IN  BOOLEAN := FALSE,
                  error_msg_table   OUT dbms_utility.uncl_array,
                  error_num_table   OUT dbms_utility.number_array)
                  RETURN BINARY_INTEGER;

The return value of these functions is the number of errors detected.

There are no restrictions on calling this function.

Parameters

Parameter Name	Description
gname	Name of the replication group.
check_genflags	Boolean flag indicating whether to check that all replicated objects have replication support generated.
check_valid_objs	Boolean flag which checks whether or not all replicated objects are valid. This check is performed at all master sites.
check_links_sched	Boolean flag to check if pushes are scheduled to all master databases.
check_links	Boolean flag which checks if the user invoking the procedure has valid database links to all master databases.
error_table	PL/SQL table of errors found.
error_msg_table ...