sorting problem

[Vadim]

NT Server 4.0 SP6 & Oracle 8.1.5 & DOA 3.4.5
on P166 / 96MB RAM computer
In my app I need sorting which I implement through
wwDBGrid's title buttons.
After several successive clicks on title I get an ORA-03113 error.
Seems it happens with all tables or views and needs from 3 to about 5-6
clicks on different columns.
The following is an example sequence:
Select * from USER$ t /* initial opening/
Select * from USER$ t ORDER BY USER# ASC /* normal */
Select * from USER$ t ORDER BY USER# DESC /* normal */
Select * from USER$ t ORDER BY USER# ASC /* normal */
Select * from USER$ t ORDER BY NAME DESC /* ORA-03113 error: end-of-file ... */

The same is true even if for each of above statements dynamically generate
new TOracleDataSet instance (all within single session).
I tried all I could by manipulating with pertaining OracleSession and OracleDataSet
properties but mainly in vain. Though I observed that enabled CountAllRecords
aggravates the situation - crash becomes faster.
Is it a bug or something?

 

[Marco Kalter]

You have probably run into an Oracle Server bug. ORA-03113 usually indicates that the server process has died. Can you mail me the user trace file from the server that corresponds to this error?

------------------
Marco Kalter
Allround Automations

 

[Franz.Raiber@Zwick.de]

Hallo Vadim,
your problem with sorting in oracle i've had too.
The bad Info: There's a bug in oracle
The good Info: There's a solution
You have to insert in Client-Registry in the path

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
the entry
NLS_SORT = BINARY

and oracle can now sort correctly
IF there are more than 1 HOME's installed, you have to insert this entry in each HOME!

I hope this is the solution for your problem!

Franz Raiber

Originally posted by Vadim:
NT Server 4.0 SP6 & Oracle 8.1.5 & DOA 3.4.5
on P166 / 96MB RAM computer
In my app I need sorting which I implement through
wwDBGrid's title buttons.
After several successive clicks on title I get an ORA-03113 error.
Seems it happens with all tables or views and needs from 3 to about 5-6
clicks on different columns.
The following is an example sequence:
Select * from USER$ t /* initial opening/
Select * from USER$ t ORDER BY USER# ASC /* normal */
Select * from USER$ t ORDER BY USER# DESC /* normal */
Select * from USER$ t ORDER BY USER# ASC /* normal */
Select * from USER$ t ORDER BY NAME DESC /* ORA-03113 error: end-of-file ... */

The same is true even if for each of above statements dynamically generate
new TOracleDataSet instance (all within single session).
I tried all I could by manipulating with pertaining OracleSession and OracleDataSet
properties but mainly in vain. Though I observed that enabled CountAllRecords
aggravates the situation - crash becomes faster.
Is it a bug or something?