Error when ORDER BY a char field

From: Vidar Tuven <vit_at_financial.ementor.no>
Date: Fri, 18 May 2001 10:50:29 GMT
Message-ID: <V77N6.354$_ub.170993664@news.telia.no>

Hi,

I have a problem when doing an ORDER BY on a char field in Oracle 8.1.5 . I get
errormessages that says:
"[Oracle][ODBC][Ora]ORA-03113 end-of-file on communication channel ."

"Data providaer or other service returned an E_FAIL status."

I try to do an ORDER BY on a char or on a varchar2- field that contains only numeric characters.This works ok in one instance of Oracle but not in an other. The error appears even when using SQL-Plus. It happens not every time, but once in a while.

Does anyone know anything regarding this, so please help me.

Regards

Vidar Received on Fri May 18 2001 - 05:50:29 CDT