DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to locate error.......

  1. #1
    Join Date
    Jul 2000
    Pune, India
    RDBMS Version: 8.1.6
    Operating System and Version: Windows 2000


    I am facing one problem. While running our application If I face an error "ORA-00904 invalid column name". I have to take that SQL statement and run from SQL*PLUS to findout which column is missing. Since SQL*PLUS shows * sign below Invalid column. Is there any other functionality or way (May be Stored Procedure or Function) to get this invalid column.

    Please help.

    Thanks & Regards,


  2. #2
    Join Date
    Nov 2000
    Birmingham, UK
    if its a procedure etc that calls the column as part of it, the procedure should be invalid (can check dba_objects). Check to see if you can compile it:

    alter procedure compile;

    If it compiles with error you can do a sho err in SQLPLUS which will show you the line number it is erroring on.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width