Delimiter //
/**
 * Checks that the contact's ref is not null
 *
 * @param int batchnum
 */
Drop Procedure if exists LOADER_CONTACTS_NORMALIZE_CONTACTS_REF_NOT_NULL//

Create Procedure LOADER_CONTACTS_NORMALIZE_CONTACTS_REF_NOT_NULL (
    In batchnum int
)
Begin
    CALL LOADER_CONTACTS_CHECK_NULL (
        'CONTACTS_REF'
        , batchnum, 0, null
    );
End //

Delimiter ;