christian
User
Junior Boarder
| Posts: 11 |   |
Karma: 0
|
|
How to insert a long string into a field CLOB
|
|
Posted: 2008/03/19 10:08 |
|
|
|
|
Hi,
How to insert a string size to values less than 8000 in Oracle 10G, field description type CLOB
I tried
SQL.Clear;
SQL.Add('Insert into TestTable (id, description) values (1, EMPTY_CLOB()) RETURNING description INTO :V1');
ParamByName('V1').AsBlob := vs_description; // String size 8737
or
ParamByName('V1').AsString := vs_description; // String size 8737
but, i receive a message "can bind a LONG value only for insert into a LONG column".
With my best regards
Christian Balz
Post edited by: christian, at: 2008/03/19 10:11
|
|
