oracle8.1.6 begin :1 := acs.add_user( user_id => :user_id, email => :email, url => :url, authority_id => :authority_id, username => :username, first_names => :first_names, last_name => :last_name, password => :hashed_password, salt => :salt, creation_user => :creation_user, creation_ip => :peeraddr, email_verified_p => :email_verified_p, member_state => :member_state ); end; begin acs_user.delete( user_id => :user_id ); end; select person.delete(:person_id) from dual; select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from cc_users u where upper(nvl(u.first_names || ' ', '') || nvl(u.last_name || ' ', '') || u.email || ' ' || nvl(u.screen_name, '')) like upper('%'||:value||'%') order by name