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
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
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 wo
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
Hi All,
Oracle 8.1.6, WinNT
I have view TIMEVIEW. I can do select * from timeview with no errors. If
I select a individual column I get 904 error.
I am doing everything from the schema owner.
Any hints
SQLWKS> desc timeview
Column NameNull?Type