Re: Error when ORDER BY a char field

the ORA-3113 on the client side means that the process on the server side has probably died due to some error. check the alertsid.log for error messages (ORA-7445 or ORA-600), or for recent dump files in udump directory.

you could try running the SQL statement on the server machine (local connection), and see if you can get a more meaningful error message.

and please refrain from crossposting to multiple oracle newsgroups. thanks.

"Vidar Tuven" <vit_at_financial.ementor.no> wrote in message news:V77N6.354$_ub.170993664_at_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 ."
>
> or
>
> "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 Sun May 20 2001 - 18:10:04 CDT