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