| bublling up warning messages from triggers and continuing [message #366762] |
Fri, 01 December 2000 14:21 |
smita sathe
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
I would like to buble up a warning message from an insert trigger to my java program. Does anybody know how to do that ? For example, here is the trigger code. After the check, I would like to give a warning message and continue excuting as opposed to stopping the execution of the code and quitting.
BEGIN
IF LENGTH(:NEW.NAME) > 21 THEN
BEGIN
dbms_output.put_line('Warning......Invalid Name Length');
RAISE invalid_name_len;
EXCEPTION
WHEN invalid_name_len THEN
raise_application_error(-20004, 'Invalid Name Length: Name length excluding Signal Name, Should be < than 21 chars');
END;
END IF;
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
