Oracle text loading limitation?

I was wondering if there was a limit that the Oracle server 8.0.3 has with loading in data.

I've heard that the size to load in a string is 4K. Is this the case? Are there data types that can process a SQL statement that allows the data to be longer than 4k?

For example:

INSERT INTO "test" (testcol)

    VALUES
        (' Imagine that this is over 4K worth of data');

Any help will be appreciated.

Kristian Received on Fri Jul 16 1999 - 13:04:26 CDT