Got this error message after running this query.
where fmuln.plan_seq_id ='179071101'
order by REQID,PLAN_ID,FM_ID
ERROR at line 8:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I get this error message when I run this as a user who has access to this table.
I do not get error message when I run this as a sys or table owner "test".
This is on Solaris 2.7 with Oracle 8.1.6.
Please help me...is there anything wrong on select query?
Click Here to Expand Forum to Full Width