Re: Help!! SQL*Loader and LONG datatype - Urgent!

There has to be a way to get this LONG type data into the database without having to go with a different party's tool. I tried doing a conventional-path load with just one record, and it doesn't like the linebreaks either, even though the data is separted by commas for the INSERT statement. Does anyone know how I can get this data into the database??

I found the following in Oracle Technet's site: LONG, RAW, LONG RAW, VARCHAR2
You can use the piecewise capabilities provided by OCIBindByName(), OCIBindByPos(), OCIDefineByPos(), OCIStmtGetPieceInfo() and OCIStmtSetPieceInfo() to perform inserts, updates or fetches involving column data of these types.

Does anyone know if I need to use these with an INSERT or is there a simpler way? I have a lot of data to load and I can't do anything until I figure this piece out.

Also, Oracle's Migration Tool for MS Access doesn't like the databases I'm trying to import the data from. I get errors when I try to use it. I've tried creating a new database and just putting one table in it, compacting and repairing the original database (the Access db), etc.

Thanks in advance,
Alethea

p.s. Thanks to those that have made suggestions!

In article <8l8mvh$p54$1_at_nnrp1.deja.com>,   Alethea <stanggirl_at_my-deja.com> wrote:
> I'm running Oracle 8.0.5. on NT. I'm using SQL*Loader to load data
 into
> existing tables. I've exported MS Access fields of the Memo datatype
> into .dat files for loading. These are fairly large fields and in the
> Oracle database, they are going into columns that are of the LONG
> datatype. I'm not sure what datatype to specify in the control file.
> I've tried using CHAR, INTEGER EXTERNAL, and RAW, but with no success.
> In the log, I get the following error for each row:
>
> ORA-01401: inserted value too large for column
>
> I tried changing the bindsize array, but I get this error on the
> command line:
>
> specified value for readsize (65535) less than bindsize (1000000)
>
> I'd appreciate any help!!
>
> Thank you,
> Alethea
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 21 2000 - 00:00:00 CDT