Log in to AnswerLog in to Follow
2020-11-11 22-46-19
Thiago Andrade
77Views
2Comments
[BulkInsert] Problems with BulkInsert in ORACLE database
Question
Database
Forge
Oracle
Service
bulkinsert
Service icon
BulkInsert
Forge component by Galter
Application Type
Service

When used with an ORACLE database, the BulkInsert throws the exception "BulkInsert: Specified cast is not valid.".

This exception occurs with attributes of the type long integer.

This is the part of the code that throws the exception:

To fix this issue the data type int should be changed to Int64 or long.


0
0
04 Apr 2022

Another important point when using an ORACLE database is to make sure that you don't use protected names in the attributes, such as "Number, Order...". The use of these names will throw an exception at the moment.

The development team should add in the code a protection for these cases, since it's possible to have a collumn, for example, named Number in ORACLE, just by using "Number".

0
0
07 Apr 2022

Another problem was found when trying to use binary type with ORACLE. I did some tweaks to make the BulkInsert accept this data type too (and other minor fixes).

If anyone needs I'm attaching the part of the code that works with ORACLE, just copy it to the extension.

Oracle.cs
1
0
08 Apr 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.