I went through a similar problem with the 904 error.  I had to use oradebug
to get a trace file to be produced.

Good luck,
Chris

-----Original Message-----
Sent: Monday, January 19, 2004 8:14 AM
To: Multiple recipients of list ORACLE-L

It turns out that the user had configured TOAD to use a table filter, which
causes it to create and store a query.  As you've probably guessed, the
query was referencing a column which no longer exists.

On a related note, I initially tried to capture the failing query using
"alter system set events='904 TRACE NAME ERRORSTACK'", but no trace files
were ever created.  Any idea what the command should really have been?

-----Original Message-----
Norris, Gregory T [ITS]
Sent: Friday, January 16, 2004 9:10 AM
To: Multiple recipients of list ORACLE-L


We're developing some schema update scripts for an in-house application,
which includes renaming an existing table, and creating a new version using
the original name.  No problem... or so I thought. :(  All seems well under
OEM and SQL+, but I have a developer who consistently gets an ORA-904 error
(invalid column name) when trying to access the new table under TOAD.

I can't think of anything weird about this table, except that the original
has some column-level grants (but not to his userid... he has
select/insert/update/delete on both tables).  I had him try exiting and
restarting TOAD, in case it was caching something relevant, but that didn't
make any apparent difference.  Any idea what might be going on?

        SQL> desc tool_request_old
         Name                    Null?    Type
         ----------------------- -------- ----------------
         TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6)
         TREQ_PEOPLE_FKEY        NOT NULL NUMBER(6)
         TREQ_SUBMIT_DATE        NOT NULL DATE
         TREQ_COMPLETE_DATE               DATE
         TREQ_STATUS             NOT NULL NUMBER(6)
         TREQ_COMMENTS                    VARCHAR2(2024)
         TREQ_BYPASS_START                DATE
         TREQ_BYPASS_END                  DATE

        SQL> desc tool_request
         Name                    Null?    Type
         ----------------------- -------- ----------------
         TREQ_ID                 NOT NULL NUMBER(6)
         TREQ_PERS_ID            NOT NULL NUMBER(6)
         TREQ_STATUS_ID          NOT NULL NUMBER(6)
         TREQ_SUBMIT_TMST        NOT NULL DATE
         TREQ_BYPASS_START_TMST           DATE
         TREQ_BYPASS_END_TMST             DATE
         TREQ_COMPLETE_TMST               DATE
         TREQ_COMMENTS                    VARCHAR2(1024)

--
My employers like me, but not enough to let me speak for them.

Greg Norris
Sprint LTD Database Administration
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Norris, Gregory T [ITS]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Norris, Gregory T [ITS]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Chris Stephens
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to