Cursor-limit problem on bulk insert. about erloci

[c-bik]

Its seems your statements are not being closed fast enough. I can suggest the following:

1. check the current setting of open_cursors in server with select name, value from v$parameter where name = 'open_cursors'; by logging into server as sysdba (default current is too low https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams138.htm#REFRN10137)
2. Try p(1000) again after increasing it to 1000 http://www.dba-oracle.com/sf_ora_01000_maximum_open_cursors_exceeded.htm
3. You may experimentally find a lower value of N in alter system set open_cursors=N... (p(M)) for N < M. But that will depend on the latency between Stmt:exec_stmt/0 <-> Stmt:close/0. Which IMHO may be difficult to formulate.

Please write back if you are still experiencing problem.

Good luck

[c-bik]

@zicaty how did it go? please let us know if you had to solve it differently. Can you please close this issue if it is resolved for you?

[c-bik]

Gave it a week to receive some kind of response. Closing!