postgresql7.1
select acs_object_id_seq.nextval
FIX ME LOB
update cr_revisions
set mime_type = :mime_type,
content = empty_blob()
where revision_id = :revision_id
returning content into :1
FIX ME PLSQL
FIX ME PLSQL
begin
:1 := content_item__new (
name => :name,
content_type => 'image',
context_id => :term_item_id,
creation_user => :user_id,
creation_ip => :peeraddr
);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
:1 := content_revision__new(
item_id => :new_item_id,
title => :title,
description => :description,
creation_user => :user_id,
creation_ip => :peeraddr
);
end;
FIX ME LOB
update cr_revisions
set mime_type = :mime_type,
content = empty_blob()
where revision_id = :new_revision_id
returning content into :1
FIX ME PLSQL
FIX ME PLSQL
begin
:1 := content_revision__new(
item_id => :new_item_id,
title => :title,
description => :description,
creation_user => :user_id,
creation_ip => :peeraddr
);
end;