ORA-01000: maximum open cursors exceeded

From: Mattias Malmgren <a2matmal_at_ulmo.stud.slu.se>
Date: Fri, 21 Aug 1998 17:58:26 +0200
Message-ID: <35DD9922.1B7A0DB2@ulmo.stud.slu.se>

I have a loop that asks for texts created at a date. After 3 texts has bean fetched from the database I get this error

ORA-01000: maximum open cursors exceeded

But just before I test :

    ...

     IF get_all%ISOPEN
     THEN
        CLOSE get_all;

    END IF;     OPEN get_all FOR
    SELECT text FROM documents WHERE date = 12;     RETURN get_all;
END; Anyone have any ideas?

Greeting Mattias Malmgren Received on Fri Aug 21 1998 - 10:58:26 CDT