Re: ORA-00904: invalid column name

A copy of this was sent to "Joao Prates" <jmmp_at_esoterica.pt> (if that email address didn't require changing) On Thu, 19 Aug 1999 00:36:57 +0100, you wrote:

>Hi,
>
>I'm getting error "ORA-00904: invalid column name" when running a stored
>procedure that compiled ok. Anyone can explain what can be causing this
>error? If a column name were in fact invalid shouldn't the compiler detect
>it at compile time? I checked the tables structure and there was no
>modification since compile time, even so I recompiled it again and the
>problem remains only at run time. Any ideas?
>
>Thank you in advance,
>
>Joćo Prates

are you using dynamic sql?
what does the procedure look like?
how are you running it?

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Aug 19 1999 - 08:53:31 CDT