There are two Clob type in one table

[snowboys]

I want to insert information to two clob type.My query is :
insert into TCJCCOUNTRYDATA (FLCOUNTRYAREAID,FSCOUNTRYSUMMARY,FSCOUNTRYSHORTHISTRY)
values CountryName,empty_Clob(),empty_Clob())
returning FSCOUNTRYSUMMARY into :summary FSCOUNTRYSHORTHISTRY into :countryheader

there is an error:ORA-00933.

Please tell me how to treat it.

snowboys

 

[Marco Kalter]

The correct returning clause syntax for multiple columns is:

returning FSCOUNTRYSUMMARY, FSCOUNTRYSHORTHISTRY
into :summary, :countryheader

------------------
Marco Kalter
Allround Automations