ORA-604 And ORA-01001 Occuring After Applying Patch 6701716 (Doc ID 729539.1)

Last updated on DECEMBER 16, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 10.2.0.4
This problem can occur on any platform.

Symptoms

The following errors are now experienced when executing a referential function after the installation of Patch 6701716 to fix a core dump that occurs from executing a function that returns a referential cursor:  

ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms