All Forums Database
Lee 6 posts Joined 03/05
15 Jan 2010
Insert in CLOB

Hello,

I have created a new table with a CLOB field intended to store a deliminated character string, however a standard INSERT statement is only loading the first character of said string.

Any thoughts or guidance as to why this is happening and how to fix please?

All input gratefully received.

Thanks,
Lee UK

Lee
Vador 36 posts Joined 08/07
21 Jan 2010

By using the import feature of SQL-Assistant, you are able to load clobs or blobs,
SQLA has parameter markers for blobs and clobs:
Insert Into Foo Values ( 'bar', ?B, ?C)

The ?B is a placeholder for blob, and ?C is a placeholder for clob

Lee 6 posts Joined 03/05
22 Jan 2010

Many thanks for that, I will investigate.

Lee

You must sign in to leave a comment.