oracle8.1.6
update lang_messages
set message = empty_clob(),
upgrade_status = :message_upgrade_status
where locale = :locale
and message_key = :message_key
and package_key = :package_key
returning message into :1
insert into lang_messages (package_key, message_key, locale, message, upgrade_status)
values (:package_key, :message_key, :locale, empty_clob(), :message_upgrade_status)
returning message into :1
update lang_message_keys
set description = empty_clob()
where message_key = :message_key
and package_key = :package_key
returning description into :1