Share |

ORA-20250: A user specified error message

Error messages starting from -20000 until -20999 are user specified error messages.

Oracle provides these range of codes so applications can raise an application specific error, which will be displayed after the chosen code.
This is done using the raise_application_error pl/sql function.

You'll have to contact the application provider should you want to have more detail about the error message.
Unless the error message is of an Oracle application or functionality, it is useless to contact Oracle for these errors.

Imagine I have a procedure which takes an argument. This arguments needs to be between 0 and 100:
create or replace procedure add_salary(pRaise number) is
begin
  if pRaise not between 0 and 100 then
    raise_application_error(-20000, 'Raise need to be between 0 and 100');
  end if;
  -- do further processing
end;
/
Procedure created.

SQL>
Now we test the procedure with a valid argument:
SQL> exec add_salary(0);

PL/SQL procedure successfully completed.
And now with an invalid argument:
SQL> exec add_salary(110);
BEGIN add_salary(110); END;

*
ERROR at line 1:
ORA-20000: Raise need to be between 0 and 100
ORA-06512: at "DEV01.ADD_SALARY", line 4
ORA-06512: at line 1
As one can see, we raised a custom error -20000 with a user defined error message.
The same thing happened with you, if you receive this error with one of our applications, you need to contact us in order to solve this problem.

So the only one who can help is the application vendor or service provider.
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-20250 Add your own message



After executing the update query i am getting the following error

ORA-20250:This record cannot be saved.The changes you are attempting to
make must be logged and the system is unable to write to the audit log.

ORA-06512:at "XYZ.ABC_SFD",line 100,
ORA-04088:error during execution of trigger "XYZ.ABC_SFD"essage

A custom trigger (XYZ.ABC_SFD) want to log a change attempt into an audit log table.

It was unable to do so and generated this custom error message.

You need to check why it was unable to log the record into an audit table. Maybe missing privileges, tablespace full, ...

 

After executing the update query i am getting the following error

ORA-20250:This record cannot be saved.The changes you are attempting to
make must be logged and the system is unable to write to the audit log.

ORA-06512:at "XYZ.ABC_SFD",line 100,
ORA-04088:error during execution of trigger "XYZ.ABC_SFD"essage

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: c4nakdmfoq25eb784


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.