Re: Error ORA00904 - Invalid Column Name -HELP

Hi Sally,

I had exactly the same problem. Here are some suggestions:

1.) writing column names in hyphans might caus exact character matching rather than upper case ( if you use odbc, this can happen; or using SQLPLUS with special otpions, I heard ..)

2.) seldom, but still there: some undrawble charaters in the line (SQL does not like ^H., \n ..or things like that in a column name). This occasionaly happens, when you cut and paste between windows..

3.) Very nasty: ODBC may transform your code badly (especilally dates) and the parser gets confused.

4.) If you have too much selfreferencing joins in your statement this wioll blow up in V8 much quicker than in V7 (6 joins allowed)

The latest problem we had with that error is not solved yet.Let me hear, if you get a solution ..

Oh, by the way. There are some (very expensive) tools out there (Patrol from IBM, SQLparse from Redwood..) which gives you some hints. If you want to see, what's really in the engine, Patrol seems heplful to me.

I guess you can analyze the latest SQL statement by v$ or s$ tables, if you have the machine for your own.

Goog luck to You,

   Christian

Sally Madeira schrieb in Nachricht <38FE0093.EF0ADF7_at_home.com>...
>I wrote a procedure to insert a resultset into a table and I am getting
>an invalid column error.
Received on Tue Apr 25 2000 - 00:00:00 CDT