oracle8.1.6
begin
:1 := weblogger_channel.new (
null,
:package_id,
NULL,
:creation_user,
:creation_ip
);
end;
begin
:1 := weblogger_channel.new (
null,
:package_id,
:creation_user,
:creation_user,
:creation_ip
);
end;
begin
:1 := rss_gen_subscr.new (
null, -- subscr_id
acs_sc_impl.get_id('RssGenerationSubscriber','pinds_blog_entries'),
-- impl_id
:summary_context_id, -- summary_context_id
:timeout, -- timeout
null, -- lastbuild
'rss_gen_subscr', -- object_type
sysdate, -- creation_date
:creation_user, -- creation_user
:creation_ip, -- creation_ip
:package_id -- context_id
);
end;
select p.package_id
from apm_packages p, acs_object_party_privilege_map perm
where p.package_key = 'lars-blogger'
and p.package_id = perm.object_id
and perm.privilege = 'create'
and perm.party_id = :user_id