Re: SQL Worksheet error message

Edward:

The 3113 is a pretty generic SQL*Net message indicative of many things. However, I would suggest you try lowering MAXDATA with >set maxdata 2048. The default is 20K. I have had this work, but believe the root cause may have something to do with the network packet size or something along those lines. Any further information you uncover while debugging this would be greatly appreciated. Please feel free to e-mail me directly. Thank-you.

Brian

In article <01be2ee3$988799b0$5501a8c0_at_edj>,   "ejiang" <ejiang_at_thru-put.com> wrote:
> I was debugging sql queries using the Oracle SQL Worksheet in the Oracle
> Enterprise Manager v. 1.3.5. The operating system is Windows NT 4.0.
> When I enter SELECT * FROM VIEW; SQL Worksheet prints the records without
> problem.
> Somehow, if I specify one or more fields in the query ( e.g. SELECT QTY
> FROM VIEW; or SELECT VIEW.QTY FROM VIEW; ),
> The following error message appears:
>
> ORA-03113:end-of-file on comunication channel
>
> The connection to the database is also lost.
>
> Your advice on the cause and/or solution to the problem is greatly
> appreciated.
>
> Edward
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 25 1998 - 10:12:54 CST