OVerflow on INSERT Statement

[SirDrinksalot]

Hi there,

I am trying to perform an INSERT into a linked Oracle Table, using the following code:

INSERT INTO JTCS_OWNER_VISITS
SELECT *
FROM Visits;

Seems simple enough, there are 10,000 records in the visits table, but when i try to run this query i get an error message that simply says 'OverFlow' but no error code. This query worked earlier when i only tried to insert 1,800 records, can anyone tell me if there is a limit to the number of records i can insert. I have linked the oracle tables using ODBC drivers (SQORA32.dll) and this has worked fine against all of the other tables except this one...

Thanks

Dan

 

[FoFa]

Sounds more like you have a column (data) that is longer than the defined Oracle column is that is receiving.

 

[SirDrinksalot]

Thanks, did figure it out in the end, it was just a crappy data problem!