Re: group by rollup problem.

From: Wojtek <>
Date: Tue, 23 Jan 2007 10:51:59 +0100
Message-ID: <ep4lsd$2vs$>

Andy Hassall napisaƂ(a):
> 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 
>> channel.
>> 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?

> 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

Thank you guys!

Unfortunately this is bad news for me. We are migrating our software from Oracle 9i to Oracle XE, and I will have to fix this bug in many places...

Anyway, thank you once again!

Wojtek Received on Tue Jan 23 2007 - 10:51:59 CET

Original text of this message