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!

chr(10) or chr(13)

FC60Mar 24 2017 — edited Mar 24 2017

Hi,

I want to create a message in a PL/SQL procedure that I use to send an email. I try with this code:

v_texte := 'Institution: ' || p_institution || ', ' || chr(10) ||

'Rôle : ' || p_role || ', ' || chr(10) ||

'Nom : ' || p_nom || ', ' || chr(10) ||

'Prénom : ' || p_prenom || ', ' || chr(10) ||

'Téléphone : ' || p_telephone || ', ' || chr(10) ||

'Texte mess.: ' || p_body;

The message arrives, but I can the results is:

Institution: AAAAAA, Rôle : BBBB, Nom : CCCCCC

and not

Institution: AAAAAA,

Rôle : BBBB,

Nom : CCCCCC

Thanks for the help.

PS: I tried also with chr(13)

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2017

Added on Mar 24 2017

#apex-discussions

8 comments

20,415 views