oracle8.1.6 begin :1 := category.new ( category_id => :category_id, locale => :locale, name => :name, description => :description, tree_id => :tree_id, parent_id => :parent_id, creation_user => :user_id, creation_ip => :creation_ip ); end; begin category.new_translation ( category_id => :category_id, locale => :default_locale, name => :name, description => :description, modifying_user => :user_id, modifying_ip => :creation_ip ); end; begin category.new_translation ( category_id => :category_id, locale => :locale, name => :name, description => :description, modifying_user => :user_id, modifying_ip => :modifying_ip ); end; begin category.edit ( category_id => :category_id, locale => :locale, name => :name, description => :description, modifying_user => :user_id, modifying_ip => :modifying_ip ); end; begin category.del ( :category_id ); end; begin category.change_parent ( category_id => :category_id, tree_id => :tree_id, parent_id => :parent_id ); end; begin category.phase_in(:category_id); end; begin category.phase_out(:category_id); end; insert into category_object_map (category_id, object_id) select :category_id, :object_id from dual where not exists (select 1 from category_object_map where category_id = :category_id and object_id = :object_id)