Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Newline in raise_application_error()

Newline in raise_application_error()

From: <sonyantony_at_hotmail.com>
Date: 7 Dec 2006 10:27:26 -0800
Message-ID: <1165516045.952844.177160@j72g2000cwa.googlegroups.com>


I need to display an error message that has multiple lines, from a trigger
raise_application_error( -20004, 'ERROR MSG LINE1 \n ERROR MSG LINE2' ) ;

But the code above prints
ERROR MSG LINE1 \n ERROR MSG LINE2

instead of
'ERROR MSG LINE1
ERROR MSG LINE2' Is there any way of doing it ?
Thanks
--sony Received on Thu Dec 07 2006 - 12:27:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US