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 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.


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.





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.