select p.first_names||' '||p.last_name as user_name, pa.email as user_email
from persons p, parties pa
where pa.party_id = p.person_id
and p.person_id = :user_id
select bug_id
from bt_auto_bugs
where error_file =:error_file
and package_id = :bug_package_id
insert into bt_auto_bugs(bug_id, package_id, error_file)
values (:bug_id, :bug_package_id, :error_file)
update bt_auto_bugs
set times_reported = times_reported + 1
where bug_id = :bug_id
select times_reported
from bt_auto_bugs
where bug_id = :bug_id