oracle8.1.6
begin
:1 := logger_project.new (
project_id => :project_id,
name => :name,
description => :description,
project_lead => :project_lead,
creation_user => :creation_user,
creation_ip => :creation_ip,
package_id => :package_id
);
end;
begin
logger_project.del(:project_id);
end;
select distinct acs_object.name(p.project_lead), project_lead
from logger_projects p,
logger_project_pkg_map ppm
where ppm.project_id = p.project_id
and ppm.package_id = :package_id