Are you asking why you get different errors on the two servers, or why =
the SQL statement is failing?
I would guess that it's failing because column g1an8 is of datatype =
NUMBER.
Are you sure that both databases are at the same patch release? And are =
the versions of SQL*Plus the same?
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Post, Ethan
>=20
> Both servers are Oracle 8.1.7.4 EE 64 bit on AIX 4.3.x,=20
> should be same patch
> and maintenance level. Anyone seen this type of behavior before? I
> connected to each database directly on the server using SQL*Plus.
>=20
>=20
> SERVER1>/
> select g1tax, count(*) from crpdta.f045143 where g1an8 in=20
> ('V','R','D')
> group by g1tax having count(*) > 1
> *
> ERROR at line 1:
> ORA-01722: invalid number
>=20
>=20
>=20
> SERVER2> select g1tax, count(*) from proddta.f045143 where g1an8 in
> ('V','R','D') group by g1tax having count(*) > 1;
> select g1tax, count(*) from proddta.f045143 where g1an8 in=20
> ('V','R','D')
> group by g1tax having count(*) > 1
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
Received on Mon Jan 26 2004 - 15:07:46 CST
