Re: ORA-00604 error occurred at recursive SQL level num

In article <MPG.e036e7dfe37bd3d989680_at_news.magma.ca>   crizan_at_magma.ca (Costin Rizan) writes:

>
> Would somebody that has encountered this error before, confirm
> that this type of error may indeed be a constraint violation and if so,
> how can I find out which constraint?
>

Don't know whether this error comes up on constraint violations. I started running into it when I started running out of cursors. It was intermittent in this situation also. When I expanded the cursor space, the problem went away. There were other problems indicating a cursor problem in this case (unable to create record groups).

--Andy
-- 
-------------------------------------------------------
| Andrew G. Tompkins    | #include <disclaimer.std.h> |
| Software Design Eng.  ------------------------------|
| Tektronix, Inc.                                     |
| Phone: (503) 627-5172      fax: (503) 627-5548      |
| email: Andrew.Tompkins_at_tek.com (work)               |
|        andytom_at_teleport.com (home)                  |
| http://www.teleport.com/~andytom/                   |
-------------------------------------------------------