My Oracle Support Banner

FRM-93652 with TOOL_ENV and NLS_DATE_FORMAT After Upgrade To 12c Form 10g Forms (Doc ID 2824534.1)

Last updated on DECEMBER 01, 2021

Applies to:

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

Symptoms

Forms 12.2.1.4 on Linux , throws
FRM-93652 after upgrading from 10g to 12c --only when using following code in a Program Unit is being called:

BEGIN
tool_env.getvar('NLS_DATE_FORMAT',v_date_format);   ------------------> If this line is commented, no errors are seen
set_application_property(PLSQL_DATE_FORMAT,v_date_format);
set_application_property(BUILTIN_DATE_FORMAT,v_date_format);
forms_ddl('ALTER_SESSION SET NLS_DATE_FORMAT = '''||v_date_format||'''');
END;

But the same code works fine in Windows.

The issue is only with Linux and with that line mentioned above.

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


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