Re: ORA-00960 "Ambiguous column..."

deangup_at_admin.ci.seattle.wa.us wrote:
: A user is getting ORA-00960 in MS ACCESS 2.0 running on WINDOWS 3.1 attaching to tables in
: ORACLE 7.0.15 running on AIX. Text of message: "Ambiguous column naming in select list." I can't find
: the message in ORACLE7 SERVER MESSAGES AND CODES MANUAL (3605-70-1292); going by
: message numbers I expected it on page 2-54. (Maybe somebody with a later version of Oracle will have it
: in their manual?) The columns in the user's ACCESS SQL statement appear to be fully qualified. Thanks
: for any information about this error!

00960, 00000, "ambiguous column naming in select list"

// *Cause: A column name in the order-by list matches more than one select
//         list columns.
// *Action: Remove duplicate column naming in select list. 

Hope this helps.

        Helen Received on Tue Jan 23 1996 - 00:00:00 CET