Alerts [message #81149] |
Thu, 16 January 2003 03:50 |
atul
Messages: 17 Registered: September 1999
|
Junior Member |
|
|
While displaying message through an alert if i want to split the message on different lines how can it be done.
e.g
Say MESSAGE IS ('SORRY THE DATA CANNOT BE STORED WRONG MONTH')
If i want to display as
'SORRY DATA NOT STORED
WRONG MONTH'
|
|
|
Re: Alerts [message #81168 is a reply to message #81149] |
Mon, 20 January 2003 06:19 |
nik
Messages: 55 Registered: January 2002
|
Member |
|
|
Hi Atul, Here's what u do;
declare constant:
v_CR CONSTANT CHAR(1) := CHR(10); -- Carriage Return
message := 'Message text here'|| V_CR --wrap to next line
'second line of text here';
bye.
|
|
|