PL/SQL (MOSC)

MOSC Banner

ORA-04092: cannot SET NLS in a trigger

in PL/SQL (MOSC) 7 commentsAnswered ✓

EBS 12.2.10

Database 19c (19.18.0.0.0)

I have a custom table on which a customer trigger has been enabled at update event. If any row is updated in table, following error appears:

-20001 ORA-20001: Oracle error -20001: ORA-20001: Oracle error -4092: ORA-04092: cannot SET NLS in a trigger
ORA-06512: at "SYS.DBMS_SESSION", line 204
has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 288
ORA-06512: at "APPS.FND_GLOBAL", line 1540
has been detected in fnd_global.set_nls.
-20001 ORA-20001: Oracle error -20001: ORA-20001: Oracle error -4092: ORA-04092: cannot SET NLS in a trigger

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center