My Oracle Support Banner

ORA-07445 [lxgu2t] or ORA-01830 Using TO_DATE Function (Doc ID 1509484.1)

Last updated on AUGUST 04, 2018

Applies to:

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


You are receiving an error similar to the one below in the alert log:

ORA-07445: exception encountered: core dump [lxgu2t()+6556] [SIGSEGV] [ADDR:0x0] [PC:0x1055D629C] [Address not mapped to object]

The trace file shows current sql and call stack information similar to the one below and the current sql contains the TO_DATE function.

Current SQL:

select to_date(d_create_ts, 'YYYY') from policy where c_line_cd = '064'

Call Stack:

lxgu2t <- lxhlinfo <- ldxlid16to8 <- ldxcdc <- obaidt <-xtyopncb <- qctcopn <- qctcpqb <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- kprball <- kkxs_parse <- pevm_icd_call_commo <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- main <- start

You might also observe the error below when trying to run the statement manually from SQL*Plus or SQL*Developer:

ORA-01830: date format picture ends before converting entire input string


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.