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 min(p.projection_id) from logger_projections p where p.project_id = :project_id and p.variable_id = :variable_id and sysdate between p.start_time and p.end_time