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.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....