My Oracle Support Banner

Wrong Date Using Name_in Function (Doc ID 734209.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

NAME_IN built-in for date column behaves differently in Forms 6i and 10.1.2.x.
In Forms use:
:block2.b := NVL(NAME_IN('block2.a'),(SYSDATE-3650));

The result in block2.b item will be 12/07/2098 instead of 12/07/1998 in Forms 10.1.2.x
Whereas in Forms 6i it displays the output as 12/07/1998.


.

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