Re: INSERT INTO a LONG datatype
Date: 1996/03/25
Message-ID: <4j7em4$lio_at_inet-nntp-gw-1.us.oracle.com>#1/1
mappler_at_cynacom.com (Matthew Appler) wrote:
>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...
>Thank you very much,
> Matthew Appler
>--------------------
>Matthew A. Appler
>mappler_at_cygnacom.com
>CyngaCom Solutions, Inc.
>(703)848-0883
>Visit our WEB PAGE! http://www.cygnacom.com
>NOTE: Views expressed belong to me, not my employer
Looks as if either the front-end tool is not capable of inserting data of size > 2000 bytes, or the tool requires some setting (that is because the tool seems to be binding the column not as a LONG but as VARCHAR). In short, contact the tool vendor.
sm Received on Mon Mar 25 1996 - 00:00:00 CET