Home » Developer & Programmer » Forms » on-error trigger does not trap ORA-28002
on-error trigger does not trap ORA-28002 [message #122853] |
Wed, 08 June 2005 15:57  |
vinodkumarn
Messages: 60 Registered: March 2005
|
Member |
|
|
I have an on-error trigger as below to trap ORA-28002 which is for conveying user that their passowrd is getting expired, but my customized error message is not showing up. I mean the ON-ERROR trigger DOES NOT fire.
DECLARE
lv_errcod NUMBER := ERROR_CODE;
lv_errtyp VARCHAR2(3) := ERROR_TYPE;
lv_errtxt VARCHAR2(80) := ERROR_TEXT;
BEGIN
IF (lv_errcod = 28002) THEN
message('Password is Expiring shortly.');
ELSE
message(lv_errtxt);
RAISE Form_Trigger_Failure;
END IF;
END;
can anyone let me know what is the problem here.
we are using forms 6i and is web based application
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Mar 07 09:10:53 CST 2025
|