Re: group by rollup problem.

From: Andy Hassall <>
Date: Mon, 22 Jan 2007 20:01:27 +0000
Message-ID: <>

[Quoted] On Mon, 22 Jan 2007 16:18:57 +0100, Wojtek <> wrote:

>I have a problem with executing my query on oracle 10g express edition.
>I have the following table:
[snip runnable testcase]
>It gives me the following error: ORA-03113: end-of-file on communication
>When the last line is commented out, it works fine.
>When you replace "substr(col,1,1)" with "col" it works fine.
>When the column's type is number, it works fine.
>Does anybody have a clue what's going on?

[Quoted]  It's a bug in Oracle XE. Look in your alert log and you'll see something like:

Mon Jan 22 19:55:22 2007
Errors in file c:\oracle\xe\app\oracle\admin\xe\udump\xe_ora_1612.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_qeesTraverseExpr+23] [PC:0x1443013] [ADDR:0x0] [UNABLE_TO_READ] []

 Unfortunately Oracle aren't keeping up with patches for XE, so you're stuck, unless you can rewrite the SQL to a form that gives the same results but is sufficiently different to avoid the bug. It looks somewhat like bug 4573980, fixed in - but XE is

Andy Hassall :: :: :: disk and FTP usage analysis tool
Received on Mon Jan 22 2007 - 21:01:27 CET

Original text of this message