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: and later   [Release: 10.2 and later ]
Oracle Server - Enterprise Edition - Version: and later    [Release: 9.2 and later]
Information in this document applies to any platform.


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


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


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