Exception ORA-07445 [msqcol()+1358] Raised On A Select Statement With FULL ANSI OUTER JOIN

(Doc ID 2388261.1)

Last updated on MAY 24, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

ORA-07445 [msqcol()+1358] error encountered on a SELECT statement.

Stack trace it's similar to

 

Explain plan for the sentence are related to FULL ANSI OUTER JOIN and using dynamic sampling

Changes

Migrate to 12.1.0.2, problem doesn't reproduce in 11.2.0.4.0 version.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms