The COMPILE option forces the Oracle Rdb server to recompile the
    stored (SQL) function. External functions are not affected.

    Use COMPILE when a function has been made invalid by the
    execution of a DROP . . . CASCADE operation. This mechanism is
    preferred over the SET FLAGS 'VALIDATE_ROUTINE' method available
    in previous versions.