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

    Use COMPILE when a procedure 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.