Title: RE: ora-904 invalid column name
Taking a Deep Breath ...
Are any columns in this view user defined functions ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
Rick,
What is the underlying view statement? I have found that there is an
object resolution difference between selecting individual columns and *. I'm
exploring exactly what happens, but the same issue can be found in
v$sort_usage, where there is a column USER (which is both a reserved
Title: RE: ora-904 invalid column name
try with quotes
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 4:06 PM
To: Multiple recipients of list ORACLE-L
Subject: ora-904 invalid column name
Hi All,
Oracle
Title: RE: ora-904 invalid column name
Rick,
I ask because in 8161 there is an internal bug that sometimes communicates (with users) by displaying ora-904 error. This happens when you have a user defined function and you are selecting from that user defined function AND you have privileges
