RE: Seems odd to me....(bug?)

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 03 Oct 2003 09:59:25 -0800
Message-ID: <F001.005D1FA9.20031003095925@fatcity.com>

see ... it says recursive SQL ... it probably mean some trigger is firing .. on the table.

Raj

-----Original Message-----
Sent: Friday, October 03, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L

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 might be. I think I had to use Access in query passthrough mode to prevent the upper case conversion so I could recreate the table properly...long time ago...and this was on 7.3...vauge memories...

??

-----Original Message-----
Sent: Thursday, October 02, 2003 5:40 PM 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  

  1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE' SQL> /   COUNT(*)

---

         1  

SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES; CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES              *

ERROR at line 1:

ORA-00955: name is already used by an existing object    

Any ideas?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Chris Stephens
  INET: ChrisStephens_at_affina.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 03 2003 - 12:59:25 CDT