Home » Developer & Programmer » JDeveloper, Java & XML » bublling up warning messages from triggers and continuing
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;
Previous Topic: a program of java about dbms_java.grant_permission
Next Topic: EJB & OAS 4.0.7.1
Goto Forum:
  


Current Time: Thu Jul 29 13:13:15 CDT 2021