Title: RE: Seems odd to me(bug?)
something other than a table?
Synonym that the inserter only has select on?
see what you can find in all_objects or all_tables
-Original Message-
From: Chris Stephens
To: Multiple recipients of list ORACLE-L
Sent: 10/2/2003 5:39 PM
Subject
Ran into somthing like this when MS Access (Old Microsoft ODBC drivers) was
used to create or copy a table from access to Oracle. It created a table
with lower case letters. The table existed but when SQLPlus is used all SQL
is converted to upper case. I don't know if this is your case but it
Chris, normally you should get only the table or view does not exist,
but you are also getting ora-0604 which leads me to the conclusion that
there's more to it them meets the eye. Also, the recursive SQL level 1
is confusing. My suggestion would be to catch the offending SQL, on the system
PROTECTED]
Sent: Friday, October 03, 2003
9:24 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Seems odd to
me(bug?)
Chris, normally you should get only the table or
view does not exist,
but you are also getting ora-0604 which leads me to the conclusion that
there's more to it them
of list ORACLE-L
Subject: Re: Seems odd to me(bug?)
Chris, normally you should get only the table or view does not
exist,
but you are also getting ora-0604 which leads me to the conclusion
that
there's more to it them meets the eye. Also, the recursive SQL level
1
is confusing. My
Title: RE: Seems odd to me(bug?)
1 select owner, object_name,
object_type, status
2 from all_objects
3* where object_name='EMPLOYEE_ROLE'
SQL /
OWNER
OBJECT_NAME
OBJECT_TYPE STATUS
Title: RE: Seems odd to me(bug?)
see ... it says recursive SQL ... it probably mean some trigger is firing ... on the table.
Raj
-Original Message-
From: Odland, Brad [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 03, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Oracle EE 8.1.7.2
HP-UX 11
Can anyone explain this?
1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)
SQL /
INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Could it be that the table has a trigger and it's trying to insert into
another table that does not exist?
Can you read from the table?
Waleed
-Original Message-
Sent: Thursday, October 02, 2003 6:40 PM
To: Multiple recipients of list ORACLE-L
Oracle EE 8.1.7.2
HP-UX 11
Can anyone
:
Sent by: Subject: Seems odd to me(bug?)
[EMAIL PROTECTED
scott @connect system/manager
system create table employee_role (a number);
Table created.
system grant all on employee_role to scott;
Grant succeeded.
system @connect scott/tiger
Connected.
scott create synonym employee_role for system.employee_role;
Synonym created.
scott select * from
11 matches
Mail list logo