oracle8.1.6 begin content_keyword.set_heading(:keyword_id, :heading); content_keyword.set_description(:keyword_id, :description); end; select content_keyword.get_heading(:id) heading, content_keyword.get_description(:id) description, case when content_keyword.is_leaf(:id) = 't' then 'keyword' else 'category' end as what from dual