I have a job that iterates off a tHashInput and for each row executes an Oracle stored procedure that uses a in/out cursor. It has about 2000 rows to process. At the stored proc step in the flow, it's processing at about 40 rows/second.
About halfway through, I get this error from the database:
ORA-01000: maximum open cursors exceeded
Is there multi-threading going on? Anything I can adjust?
Or perhaps it's not closing the result sets appropriately or quickly enough?
In general, I do a bunch of other Oracle access with no problems, but this is the first time I've hit this rate/volume.
Thanks for your reply. Yes, I'm using a shared connection. I was just suspicious that there might be a threading aspect to Talend or something else that I don't understand.