oracle8.1.6 select workflow_key from glossariesx where item_id = :glossary_item_id and revision_id = content_item.get_live_revision(:glossary_item_id) select workflow_key from glossariesx g, cr_child_rels ch where g.item_id = ch.parent_id and ch.child_id = :item_id and revision_id = content_item.get_live_revision(g.item_id) select term, definition, publish_status, live_revision, latest_revision, name, mime_type, decode(acs_permission.permission_p(item_id, :user_id, 'glossary_term_add_illustration'), 't', 1, 'f', 0) as illustration_add_p from glossary_terms_latest where item_id = :item_id select acs_object_id_seq.nextval from dual update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 begin :1 := glossary_term.new ( term => :term, definition => :definition, mime_type => :mime_type, package_id => :package_id, creation_user => :user_id, creation_ip => :peeraddr, context_id => :glossary_item_id, publish_status => :publish_status ); end;