Re: Out of cursors / Error on recursion lvl1 in Sql*Plus...

Frank schrieb:

> It has to do with the fact that there is more than 50 SELECT's having their
> resultset in the memory. If the the errors happen on a "simple select",
> it is because it creates the 51th open cursor. It sounds to me that the
> error will occur, for you, rather randomly,
> based on the use of the database that day/due to different use by the users.

Problem is, this error occurs on a LOCAL database, with only SQL*Plus open, no other users,no other tools, after an fresh dumpfile import, on the first select.

-- 
                                              Andreas
Mach's mit  /-\
            |o|
            \-/  gib KIDS keine Chance! ;-)