PL/SQL (MOSC)

MOSC Banner

Text e-mail broken into 2 lines

edited May 7, 2009 11:06PM in PL/SQL (MOSC) 1 commentAnswered
Hello!

                 I created a trigger that sends an email to me when I find a certain word. Below the line of the trigger:

if (instr(upper(:new.ds_prob_reclamado),'MAIL') <> 0) then
     strMensagem := 'Chamado : '||:new.nr_chamado||chr(13)||chr(10)||:new.ds_prob_reclamado;
     envia_email('e-mail' , 'Criacao de conta de e-mail',strMensagem);
end if;

                  I would the value of variable strMensagem be displayed on 2 lines, but everything is displayed in a row only.

                  Example:

                  I would like:

                        Chamado:  9999999

                         XXXXXXXXXXXXX yyyyyyyyyyyyyyyyyyyyyyyyy GGGGGGGGGGGGGGGG

                  But I received this:

                          Chamado: 9999999 XXXXXXXXXXXXXXXX yyyyyyyyyyyyyyyyyyyyyyy GGGGGGGGGGGGGGGGGG

                 How do I do that?

                 Otherwise, I would like the content display special caracters (á, é, ã, etc.). Instead, it appears '?'. What do I do ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center