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!

Email body - Text Area problem

MaryMJun 22 2011 — edited Jul 7 2011
Hello,

I have an email form set up in my application, (3.2), It has a multi select box, 3 text fields and a text area with counter.
when I enter data in the text area and keep typing past 1000 chars and not hit enter, the received email will create a new line with a ! at the 1000th character, and then create a new line. The text area is varchar2(4000). I have searched for days on how to fix this, Please help.. I need the text area to do a line break on the 1000th character.
DECLARE
 
l_id number;
 
BEGIN
 
   select email_id into from_add from user_mas where user_id=:app_user;
 
   l_id:=APEX_MAIL.SEND(
        p_to        => marymcarr@yahoo.com, -- change to your email address
        p_from      => mary.carr@usmc.mil,
        P_subj      => :p4_subj,
        p_body      => :p4_msg_body);
                                            
  
apex_mail.push_queue;

END;
We use Outlook 2007.

Thanks,
Mary
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jun 22 2011
12 comments
933 views