This setting is for Oracle DB. Check below link for range of open_cursors
I think it will be same for Oracle 11g and 12c. Re-check once with your DBA
Thank you Mady,
It doesn't seem to be a good approach to increase the open_cursors parameter. What if the file contains more than 70K rows?
Have a look at using the Open Interface Adapter to populate the Open Interface table, it will be much more efficient and scalable in terms of inserting potentially large numbers of records
Agree with your point.
Thank you all,
The problem is resolved, it was linked to an other fdmAPI.executequery() within the loop.
I changed the process to query one time the database outside the loop and put the result in a list.
the list variable is used in the loop instead of query the database every loop.