Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Context Cartridge ctxload utility
If you are on Oracle 8 and know that your text files will have less than
4000 chars at most, try loading a column defined as a VARCHAR2(4000) and
see if you still get the error. Oracle does not treat text that is stored
in a column defined as a LONG datatype as normal text data.
Sven. (sven_at_bc.sympatico.ca)
sb wrote:
> I am trying to load a text file thru the ctxload utility into a table
> column (datatype of long) and am receiving the following error message:
>
> DRG-11514: encountered unrecoverable error on line 1491
> DRG-11508: long data on line 1491 not found or invalid
> DRG-11505: long value overflowed specified buffer on line 1491
>
> Explanation given for DRG-11505:
> "long value overflowed specified buffer on line %(1)s"
> // *Cause: long buffer length insufficient for long data length
> // *Action: increase longsize parameter
> // *Mnemonic: LD_LONGFAIL
> //
>
> Hmmm...well, unfortunately I am not sure what this means, and what I
> need to do. I'm very new to Context (maybe this doesn't have to do
> directly with Context??), so ideas or solutions would be greatly
> appreciated.
Received on Thu Mar 18 1999 - 15:40:59 CST