OraFAQ Forum: SQL & PL/SQL » error occurred at recursive SQL level 1. how can I correct this?

Home » SQL & PL/SQL » SQL & PL/SQL » error occurred at recursive SQL level 1. how can I correct this?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error occurred at recursive SQL level 1. how can I correct this? [message #1694]

Thu, 23 May 2002 01:23

Prathee
Messages: 9
Registered: May 2002

Junior Member

Hi,
whenever I am trying to access soem tables which is already existing I am getting an error
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: invalid column name

Can anybody tell how can I correct this problem??

Regds
Prathee

Report message to a moderator

Re: error occurred at recursive SQL level 1. how can I correct this? [message #1702 is a reply to message #1694]

Thu, 23 May 2002 13:20

pavani
Messages: 32
Registered: April 2002

Member

try using schema,even though the tables r in u'r schema just make a try some times computer acts fuuny.make a try and let me know.
and did u have the tables on the same dirctory u r working on now make sure of that also

Report message to a moderator

Re: error occurred at recursive SQL level 1. how can I correct this? [message #2919 is a reply to message #1702]

Wed, 21 August 2002 10:17

Chris van Mels
Messages: 1
Registered: August 2002

Junior Member

Encountered same error (perhaps different circumstances).

Solution that worked for me:

Log into "Oracle Storage Manager" as SYS and increase the storage limits on the SYSTEM tablespace
datafile(s).

Report message to a moderator

Previous Topic:	Reverse some characters in a string
Next Topic:	Cursor record counts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 16:09:15 CDT 2024