oracle8.1.6 update lang_messages set registered_p = 't' ,message = empty_clob() where lang = :lang and key = :key returning message into :1 insert into lang_messages (key, lang, message, registered_p) values (:key, :lang, empty_clob(),'t') returning message into :1