Home » Developer & Programmer » Forms » FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed
FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed [message #682022] Sun, 27 September 2020 11:38 Go to next message
SysEngineer
Messages: 1
Registered: September 2020
Junior Member
HELLO
all users suddenly got this error is there anyone knows how to solve this issue the message as the following :-

FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed

Smile
Re: FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed [message #682023 is a reply to message #682022] Sun, 27 September 2020 12:23 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't know anything about this package but it seems that either the synonym or the package or the privilege on it has been deleted.
So post the result of:
select owner, object_type from dba_objects where object_name = 'DBMS_ERROR_CODE';
select grantee, privilege, owner from dba_tab_privs where table_name = 'DBMS_ERROR_CODE';
Before, Please read How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Previous Topic: How to restrict paste (ctrl+v) option in any field in oracle forms
Next Topic: Forms 12c problem
Goto Forum:
  


Current Time: Thu Mar 28 10:32:18 CDT 2024