Oracle stored procedure error: maximum open cursors exceeded

Four Stars

Oracle stored procedure error: maximum open cursors exceeded

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.

Capture.PNG

Ten Stars

Re: Oracle stored procedure error: maximum open cursors exceeded

I cant tell if your tOracleSP is creating a connection to Oracle or you use a shared connection (which I suggest doing), however ... there's a max cursor on db/oracle you could increase it by asking your DBA.

I found this thread, which is quite interesting to read.
https://stackoverflow.com/questions/12192592/java-sql-sqlexception-ora-01000-maximum-open-cursors-ex...
Four Stars

Re: Oracle stored procedure error: maximum open cursors exceeded

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now