Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00604: error occurred at recursive SQL level 2

ranz_dbaJun 26 2010 — edited Jun 28 2010
Hello,

I am trying to create a simple table and I am getting a ora error as below.

SQL> create table album(name varchar2(100),image blob);
create table album(name varchar2(100),image blob)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows


how to resolve this?Any help..

Thanks,
Ranz.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2010
Added on Jun 26 2010
17 comments
26,107 views