How to locate error.......

[shailesh]

RDBMS Version: 8.1.6
Operating System and Version: Windows 2000

Hi,

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,

Shailesh

[fraze]

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.