oracle8.1.6
select case when exists (select 1
from acs_object_types t
where t.dynamic_p = 't'
and t.object_type = :object_type)
then 1 else 0 end
from dual
select case when exists (select 1
from user_objects
where status = 'INVALID'
and object_name = upper(:package_name)
and object_type = upper(:type))
then 0 else 1 end
from dual
select acs_object.name(:user_id) as author,
sysdate as creation_date
from dual
select acs_object.name(:user_id) as author,
sysdate as creation_date
from dual
BEGIN
:1 := ${package_name}.new([plsql_utility::generate_attribute_parameter_call \
-prepend ":" \
-indent [expr [string length $package_name] + 29] \
$pieces]
);
END;