How to display and error message together (with variable) in a trigger?

From: <kickerchua_at_audiophile.com>
Date: Fri, 14 Aug 1998 19:06:30 GMT
Message-ID: <6r21rm$ac7$1@nnrp1.dejanews.com>

hi all, i am building a trigger that will stop an insert.

when the condition is met, i want it to display a line like:

'You cannot booked this room because it have been booked by ???'

where ??? is and variable in the trigger.

even though i can use "dbms_output.put_line" to do this but it will not show if i add "raise_application_error" to stop the insert.

can anybody help me out, thank you very much. pls reply to me via email to choonkeng_at_yahoo.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 14 1998 - 14:06:30 CDT