OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » error log

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error log [message #9327]

Tue, 04 November 2003 22:41

jseven
Messages: 28
Registered: October 2003

Junior Member

Hi,
I am having 15 columns in a table and the table is having huge vol. of data, say in, lakhs. i set linesize 1200 and width 1000. when i am trying to select the data from that table, an error log is generated by sqlplusw.exe and my oracle is automatically quitting out. How to overcome that.

Please suggest
Jseven

Report message to a moderator

Re: error log [message #9328 is a reply to message #9327]

Tue, 04 November 2003 23:11

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What version of Oracle and OS? What version of SQL*Plus?
And what does the error log tell you
MHE

Report message to a moderator

Re: error log [message #9329 is a reply to message #9328]

Tue, 04 November 2003 23:18

jseven
Messages: 28
Registered: October 2003

Junior Member

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

O/S is: Windows 2000

error log: program Error
sqlplusw.exe caused an error and will be closed by windows
error log created

Report message to a moderator

Re: error log [message #9333 is a reply to message #9329]

Wed, 05 November 2003 02:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Are you spooling to a file?

MHE

Report message to a moderator

Re: error log [message #9336 is a reply to message #9333]

Wed, 05 November 2003 03:12

jseven
Messages: 28
Registered: October 2003

Junior Member

Hi,

I am not spooling it. When the screen is scrolling down the error is thrown in the mid.

Report message to a moderator

Re: error log [message #9340 is a reply to message #9336]

Wed, 05 November 2003 04:07

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Strange. Sorry, I don't have any idea. Try looking on Metalink. Perhaps a newer version Of SQL*Plus?

MHE

Report message to a moderator

Re: error log [message #9341 is a reply to message #9340]

Wed, 05 November 2003 04:14

jseven
Messages: 28
Registered: October 2003

Junior Member

Thanks Maaher. But thats fact. Anyhow thanks for your constant follow up.

Regards,
Jseven

Report message to a moderator

Re: error log [message #9344 is a reply to message #9329]

Wed, 05 November 2003 05:15

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Is this the case with multiple clients ? or just with one PC ? If its just with one PC,maybe you need to reinstall it (ie the client).

Did you try resetting all Sqlplusw environment parameters to the default ?

How about sqlplus.exe ? (ie command line)

-Thiru

Report message to a moderator

Previous Topic:	populate records
Next Topic:	urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:55:12 CDT 2024