Problem With Alias and Rowid
ildelianAug 22 2012 — edited Aug 22 2012Good day.
In the logs of my Oracle Database i can find this errors:
** 2012-08-01 09:31:44.219
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [joxftp_()+120] [SIGSEGV] [Address not mapped to object] [140] [] []
ORA-00918: column ambiguously defined
Current SQL statement for this session:
SELECT ESTADO, ROWID InternalRowid FROM ESTADO E, AGRUESTADO GRU WHERE GRU.ESTADO=E.ESTADO AND GRU.AGRUPACION= 12 AND E.ESTADO= 14
the problem is that the original Query on my application is
SELECT E.ESTADO FROM ESTADO E, AGRUESTADO GRU WHERE GRU.ESTADO=E.ESTADO AND GRU.AGRUPACION= 12 AND E.ESTADO= 14
and I don't use ROWID on any query.
The question is , Why the BBDD add he RowId and delete the alias of the Query?
Is the problem on the BBDD or is the problem on the Oracle cliente of the users?
The arquitecture of the APP is
VB6 -> Cliente Oracle (Normallly 8.1i) -> BBDD Oracle 8i
Sorry for my bad English.
Thanks.
Edited by: user13628972 on 22-ago-2012 1:47