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)