Re: Error ORA-604/1000

From: Stephen Cheung <stephenc_at_cs.utexas.edu>
Date: 1997/10/04
Message-ID: <615h57$i0g$1@buttons.cs.utexas.edu>#1/1

: The code is for a Delete_All routine which removes all records from : a table.

: : > often get the following sequence of errors:
: : >
: : > ORA-00604 error occurred at recursive level 1
: : > ORA-01000 maximum open cursors exceeded

Are you getting rid of the entire table? if so, just TRUNCATE it instead.

Otherwise, pump up that open_cursors value some more and restart the instance.

stephen cheung

-- 
Stephen Cheung
512-916-8324 anytime.
stephen_at_cyberservices.com

Received on Sat Oct 04 1997 - 00:00:00 CDT