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);