How to return ORA-02922 error code from a trigger

[egavish]

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?

[akkerend]

Try:

DECLARE
ora2292 EXCEPTION;
PRAGMA EXCEPTION_INIT(ora2292, -2292);
BEGIN
RAISE ora2292;
END;
/