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;