My Oracle Support Banner

ORA-07445: [ldxsnf] with KUP-03018: invalid date mask "" specified for column (Doc ID 1482732.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Stack Trace:

============

ldxsnf ldxsto kudmgdt kudmgdt kudmgfl kudmgfl kudmgfl kudmgfl kudmiparms kudmxo

Plan Table
============
---------------------------------------------------------------+-----------------------------------+-------------------------+
| Id  | Operation                         | Name               | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib |
---------------------------------------------------------------+-----------------------------------+-------------------------+
| 7   |        EXTERNAL TABLE ACCESS FULL | <EXTERNAL_TABLE_NAME> |  8168 |  207K |     2 |  00:00:01 |:Q1000| PCWP |           |
---------------------------------------------------------------+----------------


In this case the error occurred when executing the statement below:


/* SQL Analyze(1) */ select /*+  full(t)    parallel(t,default) parallel_index(t,default) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad  */

to_char(count("<COLUMN_DATE1>")),   --> type of column <COLUMN_DATE1> is DATE

to_char(substrb(dump(min("<COLUMN_DATE2>"),16,0,32),1,120))--->  type of column <COLUMN_DATE2> is DATE.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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