INSERT LONG problems

From: <nzjnd4_at_my-deja.com>
Date: Thu, 06 Jan 2000 18:10:56 GMT
Message-ID: <852lr1$655$1@nnrp1.deja.com>

Hello all,

This sounds like a newbie question:) How do you insert a large amount of text into a LONG column? Oracle keeps giving complaining the insert string is two long. The Oracle reference says this:

ORA-01704: string literal too long
Cause: A quoted string specified as a constant was too long.

Action: Quoted strings may not contain more than 2000 characters.

Then how in the heck do you load data into a column that's supposed to hold 2GB or char data???!!!

Thanks to all!
--Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 12:10:56 CST