oracle8.1.6 begin content_item.set_release_period( item_id => :item_id, start_when => $start_when, end_when => $end_when ); end; select content_item.is_publishable( :item_id ) from dual select content_item.is_published( :item_id ) from dual select NVL(publish_status, 'production') as publish_status, to_char(NVL(start_when, sysdate), 'YYYY MM DD HH24 MI SS') start_when, to_char(NVL(end_when, sysdate + 365), 'YYYY MM DD HH24 MI SS') end_when from cr_items i, cr_release_periods r where i.item_id = :item_id and i.item_id = r.item_id (+)