oracle8.1.6 select version_name from apm_package_versions where package_key = :package_key and version_id = apm_package.highest_version(:package_key) begin :1 := apm.register_parameter( parameter_id => :parameter_id, package_key => :package_key, parameter_name => :parameter_name, description => :description, scope => :scope, datatype => :datatype, default_value => :default_value, section_name => :section_name, min_n_values => :min_n_values, max_n_values => :max_n_values ); end; begin apm.unregister_parameter(:parameter_id); end; begin :1 := apm_package_version.add_dependency( dependency_type => :dependency_type, dependency_id => :dependency_id, version_id => :version_id, dependency_uri => :dependency_uri, dependency_version => :dependency_version ); end; begin apm_package_version.remove_dependency( dependency_id => :dependency_id ); end; begin :1 := apm_package_version.add_interface( interface_id => :interface_id, version_id => :version_id, interface_uri => :interface_uri, interface_version => :interface_version ); end; begin apm_package_version.remove_interface( interface_id => :interface_id ); end; begin :1 := apm_package.new( package_id => :package_id, instance_name => :instance_name, package_key => :package_key, context_id => :context_id ); end; begin apm_package.del( package_id => :package_id ); end; select apm_parameter_value.new( package_id => :package_id, parameter_id => ap.parameter_id, value => ap.default_value) from apm_parameters ap where ap.package_key = :new_package_key and not exists (select 1 from apm_parameters ap2 where ap2.package_key = :old_package_key and ap2.parameter_name = ap.parameter_name)