Re: Error ORA00904 - Invalid Column Name -HELP

In article <38FE0471.D3059C58_at_home.com>, Sally Madeira <softsense_at_home.com> writes:

>OK,
>
>So I can post my code but what ggod will that do since you are not
>familiar
>with the columns. Like I said I was wondering if anyone had come into
>this
>error before and what tools are available to trouble shoot pl/sql
>procs. I am
>more interested in tools for debugging. I am guit sure you do not want
>to trudge
>through 400 lines of code!!!!!
>

The best tool tends to be another pair of eyes :-)

if you don't think it is worth your time to post the code, (believe it or not people will actually look at code postings) then here is a generic answer :-(

ORA-00904 invalid column name

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.

Paul in VT Received on Wed Apr 19 2000 - 00:00:00 CDT