postgresql7.1
FIX ME LOB
insert into acs_contents
(content_id, content, searchable_p, nls_language, mime_type)
values
(:object_id,empty_blob(),:searchable_p,:nls_language,:content_type)
FIX ME LOB
update acs_contents
set content = empty_blob()
where content_id = :object_id
returning content into :1
FIX ME LOB
insert into acs_contents
(content_id, content, searchable_p, nls_language, mime_type)
values
(:object_id,empty_blob(),:searchable_p,:nls_language,:content_type)
FIX ME LOB
update acs_contents
set content = empty_blob()
where content_id = :object_id
returning content into :1
select acs_mail_gc_object__new (
:object_id, -- gc_object_id
'acs_mail_gc_object', -- object_type
now(), -- creation_date
:creation_user, -- creation_user
:creation_ip, -- creation_ip
null -- context_id
);
select acs_mail_body__new (
:body_id, -- body_id
:body_reply_to, -- body_reply_to
:body_from, -- body_from
:body_date, -- body_date
:header_message_id, -- header_message_id
:header_reply_to, -- header_reply_to
:header_subject, -- header_subject
:header_from, -- header_from
:header_to, -- header_to
:content_object_id, -- content_object_id
:creation_user, -- creation_user
:creation_ip -- creation_ip
);
select acs_mail_body__body_p (:object_id);
select acs_mail_body__clone (
:old_body_id, -- old_body_id
:body_id, -- body_id
:creation_user, -- creation_user
:creation_ip -- creation_ip
);
select acs_mail_body__set_content_object (
:body_id, -- body_id
:content_object_id -- content_object_id
);
select acs_mail_multipart__new (
:multipart_id, -- multipart_id
:multipart_kind, -- multipart_kind
:creation_user, -- creation_user
:creation_ip -- creation_ip
);
select acs_mail_multipart__multipart_p (:object_id);
select acs_mail_multipart__add_content (
:multipart_id, -- multipart_id
:content_object_id -- content_object_id
);
select acs_mail_link__new (
:mail_link_id, -- mail_link_id
:body_id, -- body_id
:context_id, -- context_id
:creation_user, -- creation_user
:creation_ip -- creation_ip
);
select acs_mail_link__link_p (:object_id);