hi Albert,

You can display a message in Oracle report builder by using the standard built-in srw.message.

The basic syntax for using this package is:

srw.message(error_no,'YOUR MESSAGE');

the error no will appear along with the message text. and here is the sample to do this in a particular function

FUNCTION chck_sal RETURN BOOLEAN IS
BEGIN
  IF :sal < 0 THEN SRW.MESSAGE(
    100,
    'There is employee that take negative salary.'
  );
RAISE SRW.PROGRAM_ABORT;
ELSE :bonus := :sal * .01;
END IF;
RETURN(TRUE);
END;