ORA-20250: A user specified error message
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 1As 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.
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
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.
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.
