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, rownum as row_id from cc_users where user_id = :user_id begin membership_rel.approve( rel_id => :rel_id ); end; begin membership_rel.ban( rel_id => :rel_id ); end; begin membership_rel.reject( rel_id => :rel_id ); end; begin membership_rel.deleted( rel_id => :rel_id ); end; begin membership_rel.unapprove( rel_id => :rel_id ); end; begin acs_user.approve_email ( user_id => :user_id ); end; begin acs_user.unapprove_email ( user_id => :user_id ); end;