[BulkInsert] BulkInsert : Specified cast is not valid
bulkinsert
Service icon
Forge component by Galter
Application Type
Traditional Web

I followed full to use BulkInsert but i get this error.

Can show me how to fix it?
 

mvp_badge
MVP

Hi Nghiem,

Have you checked Service Center to see if you can get more details about the error?

Sorry but i don't know what them say

mvp_badge
MVP

Well, it says it goes wrong inserting into the Oracle database. So basically you provide data to bulk insert, but there's data with a different data type than the database thinks it should be, and the database can't cast it (e.g. when you have a Text attribute containing "A" and the database expects an integer, or something similar).

But i export from this table and then bulkinsert into a table which have same design( attribute and type)

mvp_badge
MVP

There must still be an incompatability somewhere, as otherwise you wouldn't get this cast error.

mvp_badge
MVP

That's a generic error. You need to check Service Center to see what caused it.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.