Recent content by 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...

My table: create table testclob (name char(10),contents clob); First: when my SQl is : insert into testclob (name,contents) values(10,empt_clob()) SetComplexVariable('contents', LOB) is an error: 'unknown variable: :contents' Where variable of 'contents' is defined? second...

When I insert information into Clob of Oracle by TOracleQuery,There is an error:ORA-01704. My Sql:'insert into table (id,clob_col) values(10,str)',the str is string whose length is more than 4000. Please tell me how to treat it . Thanks.