IS_DB_SIGNATURE_VALID Function

24.11 IS_DB_SIGNATURE_VALID Function

The IS_DB_SIGNATURE_VALID function returns whether the instance parameter DB_SIGNATURE matches the value of the function db_signature. If the instance parameter is not set (the default), also return true.

Syntax

FUNCTION IS_DB_SIGNATURE_VALID
    RETURN BOOLEAN;

Example

The following example prints the signature is valid.

begin
    sys.dbms_output.put_line (
        case when apex_instance_admin.is_db_signature_valid
        then 'signature is valid, features are enabled'
        else 'signature differs (cloned db), features are disabled'
        end );
end;