I have a trigger that needs to return the ORA-02292 error code to the Java application.
raise_application_error(...), DOES NOT allow 02922 error value.
Is there another way to return such error code to the application from a trigger?
Printable View
I have a trigger that needs to return the ORA-02292 error code to the Java application.
raise_application_error(...), DOES NOT allow 02922 error value.
Is there another way to return such error code to the application from a trigger?
Try:
DECLARE
ora2292 EXCEPTION;
PRAGMA EXCEPTION_INIT(ora2292, -2292);
BEGIN
RAISE ora2292;
END;
/