oracle8.1.6 begin :1 := apm_package.highest_version ( package_key => :package_key ); end; begin :1 := apm_package.num_instances( package_key => :package_key ); end; begin :1 := apm.register_parameter( parameter_id => :parameter_id, parameter_name => :parameter_name, package_key => :package_key, description => :description, datatype => :datatype, default_value => :default_value, section_name => :section_name, min_n_values => :min_n_values, max_n_values => :max_n_values ); end; select v.package_id, p.parameter_name, nvl(p.default_value, v.attr_value) as attr_value from apm_parameters p, apm_parameter_values v where p.package_key = :package_key and p.parameter_id = v.parameter_id (+) begin :1 := apm_package_version.add_dependency( 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; select decode(count(*), 0, 0, 1) from apm_package_versions where package_key = :package_key and version_name = :version_name select decode(count(*), 0, 0, 1) from apm_package_versions where package_key = :package_key and version_name = :version_name 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.delete( package_id => :package_id ); end; select site_node.url(node_id) from site_nodes where object_id = :package_id