ORA-7445 [ldxite] on Select Trunc() or Select TO_DATE

(Doc ID 464681.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Oracle Server - Enterprise Edition - Version: 9.2.0.7 and later    [Release: 9.2 and later]
Information in this document applies to any platform.

Symptoms

1. A select statement containing a TRUNC() function on a date field fails with ORA-7445 with the following stack:

ldxite evadid evaopn2 expepr expeal qerixFetch qertbFetchByRowID qerjoFetch qerjoFetch qerjoFetch qerpfFetch qerbFetchByRowid rwsfcd kpfrws


-Or-


2. A select statement with a TO_DATE function fails with ORA-7445 [LDXITE()] [SIGBUS] [INVALID ADDRESS ALIGNMENT] and one of the following stacks:

ldxite evadid evaopn2 kpofcr qerflFetchOutside opifch2 kpoal8

sighndlr call_user_handler evadid evaopn2 qerwnRowP qerwnFetch qervwFetch

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