update static_portal_content set package_id = :selected_community where content_id = :object_id update portal_element_map set page_id=:new_page_id where page_id=:old_page_id and pretty_name=(select pretty_name from static_portal_content where content_id=:object_id); SELECT body as content,pretty_name FROM static_portal_content WHERE content_id=:object_id