Re: ORA-00960 "Ambiguous column..."
Date: 1996/01/23
Message-ID: <3105015C.433B_at_uswest.com>#1/1
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!
From the Release 7.2 Oracle7 Server Messages guide:
ORA-00960 ambiguous column naming in select list
Cause A column name in the order-by list matches more than one
select list column.
Action Remove the duplicate column naming in the select list.
I would look at the entire select statement including the order by and make sure that Access is fully qualifying the order-by as well.
Jerry.
Jerry Bull, Sr. MTS Phone: 303-624-3073 U S WEST Technologies Fax: 303-624-8462931 14th Street, Suite 920 Email: gbbull_at_uswest.com Denver, CO 80202
Received on Tue Jan 23 1996 - 00:00:00 CET