Qkswcdriver

ORA-07445 Exception Encountered: Core Dump [Qkswcdriver()+180] [ID 1384785.1]

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

ORA-07445: exception encountered: core dump [qkswcDriver()+180] when executing query that contains a WITH clause.

11.1.0.7 returns ORA-01762.

Cause

This is due to unpublished bug 10255657 - ORA-03113 WHEN NESTED WITH CLAUSE QUERY IS NOT REFERENCED IN MAIN QUERY

For example:

WITH test AS ( SELECT 1 FROM (SELECT 2 FROM DUAL) )
SELECT 3 FROM DUAL;

The main query block is essentially a seperate query which does not reference the named TEST query at all.

Solution

The error is fixed in 11.2.0.4 

Fix:

Download and apply the patch 10255657, if its available for your Version & Platform 

Workaround:

Edit the query to remove the WITH clause since it is not being accessed.