oracle8.1.6 begin :1 := logger_variable.new ( variable_id => :variable_id, name => :name, unit => :unit, type => :type, creation_user => :creation_user, creation_ip => :creation_ip, package_id => :package_id ); end; begin logger_variable.del(:variable_id); end; select q.* from (select variable_id from logger_variables order by variable_id) q where rownum = 1