SQL & PL/SQL

Dear All,

We have this Data warehouse running every night to load data from our main database to reporting database.

The DWH has been running fine for past few years until it failed yesterday with this error:

ORA-01000: maximum open cursors exceeded

The surprising part is, we have several procedures running parallely, and only a sleected proc failed with this error yesterday and today.
Even after this proc failing, the other procs went ahead and got completed.

If the problem is due to maximum number of cursors exceeding, then why other procedures are running fine even after this specific proc failing.

I checked the procedure code. We are opening a cursor and closing it.
I can copy paste the procedure code here if needed.

Any help would be much appreciated.

Thanks.