select count(*)
from bt_projects
select acs_object_id_seq.nextval as component_id
from dual
insert into bt_components
(component_id, project_id, component_name, maintainer)
values
(:component_id, :package_id, 'Foo', :user_id)
select acs_object_id_seq.nextval as bug_id
from dual