Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Line break in success message

askMax - Maxime TremblayMar 12 2009 — edited Mar 13 2009
I would like to display success messages this way:
Message1
Message2
Message3
...

But it currently is displayed this way:
Message1Message2Message3...

I tried combining my processes into one process like this
declare
   v_vc_message   varchar2(200);
begin
   -- process 1
   /* my process*/
   v_vc_message := 'Succes message1';
   
   -- process 2
   /* my process*/
   
   if v_vc_message is null then
      v_vc_message := 'Succes message2';
   else
      v_vc_message := v_vc_message || *[char_for_line_break]* || 'Succes message2';
   end if;
   
   :P17_MESSAGE_PR := v_vc_message;
exception when others then 
   :P17_MESSAGE_PR := 'Error message';
end;
and then I put &P17_MESSAGE_PR. in my success and error message

I tried different things to get a line break.
I tried
'<br>'
'&# 60;br&# 62;'  (without the spaces)
chr(10) || chr(13)
Anyone can help me ?

Thanks
This post has been answered by ittichai on Mar 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2009
Added on Mar 12 2009
2 comments
797 views