Re: INSERT INTO a LONG datatype

> mappler_at_cynacom.com (Matthew Appler) writes:
> I am trying to insert data into a table in a column that is a LONG. I have
> met with marginal success and I believe the problem is that I am formulating
> my SQL statement incorrectly.
>
> For example, if I enter the following statement:
>
> INSERT INTO tablename
> VALUES (254, 'Test', 'This is the long value');
>
> It works just fine (assuming the last column is the long column). However, if
> the last string is > 2000 bytes I get an error that the string literal is too
> long. ie: if I quote more than 2000bytes, it doesn't work.
>
> Therefore, how do I insert more than 2000 bytes???? Any help would be greatly
> appreciated...
>>>>

Use a 3GL language, e.g., Pro*C. SQL*Plus does not support literals greater than 2000 characters.

Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe Received on Tue Mar 26 1996 - 00:00:00 CET