ORA-01000 Max. No. of Open Cursors Exceeded in Function

An interface of our application server is currently blocked after the error message "ORA-01000 Maximum number of open cursors exceeded" occurs. The only way to be able to send request is to shutdown and restart the application server.

Together with the error message ORA-01000 we get an ORA-06512 error with reference to a PL/SQL function. It seems to me that the open cursor problem is caused by this function, which I inserted below:

CREATE OR REPLACE FUNCTION "FCT_GET_ELEMENT_LONG_NAME"

                  (assignedElement IN
PD_PROD_HIER.ASSIGNED_ELEMENT_ID%TYPE,
                  assignedArticle IN

      INTO elementLongName
      FROM PD_HIER_ELEM
      WHERE UNIQUEID = assignedElement;

      INTO elementLongName
      FROM PD_ART_DATA
      WHERE UNIQUEID = assignedArticle;

Does anybody have an idea why this function causes the error with the exceeding number of open cursors? Or is the problem somewhere else?

Thanks
Michael Received on Tue Dec 17 2002 - 10:28:24 CET