oracle8.1.6 select email_verified_p as email_verified_p_old, member_state as member_state_old, first_names || ' ' || last_name as name, email, rel_id from cc_users where user_id = :user_id begin acs_user.approve_email ( user_id => :user_id ); end; begin acs_user.unapprove_email ( user_id => :user_id ); end;