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