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

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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

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