Help with odd ORA 3113 Error

Hello All,

  We are currently running across an odd Oracle error/bug. We are attempting a simple SQL query, and are being disconnect from the database every time we attempt it.

The code is as follows:

select count(*)
 from table_a
 where usercode4 = 'DX'
 and usercode1 = 'ACTV'
/

From UNIX we get kicked back to the $ prompt, from SQL*Plus client side (Win 95) we get ORA-3113 enc of communication channel (which makes sense, since it is automatically disconnecting from the database)

But if we try this :

select count(*)
 from table_a
 where usercode4 = 'DM'
 and usercode1 = 'ACTV'
/

We get our results back OK. (DX and DM are both values in the usercode4 column).

Has anyone ever seen this happen before? Any help is greatly appreciated.

DB version 7.3.2.3
DG Platform

TIA,
Joe Received on Wed Apr 29 1998 - 00:00:00 CDT