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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

losing carriage returns in textarea / using plpdf to generate report

692062Jun 18 2010 — edited Jun 19 2010
Hello,
I'm using Apex 3.1.1 and Oracle 10g database. I would appreciate any suggestions on how I can preserve carriage returns in a textarea when sending the text to a package that generates a report. Please see example of current problem (below code). I'm using an onkeypress function to check for keycode = 13 when the Enter key is pressed -- that is working. I also created an alert to show the url value -- I can see the text on multiple lines, so that appears to be working as well. The textarea value parameter in the package is defined as varchar2. Per the support folks at plpdf.com, chr(13) indicates an explicit line break, and they told me to check my text. I don't know what I'm missing. Thank you for any suggestions you may have.

Lisa
  function callPLPDFRep() 
  {
      var url;
      url = '#OWNER#.' + $x('P&APP_PAGE_ID._REPORT_PROCEDURE').value + '?' + build_params();

      w = open(url, "winPDFRep", "Scrollbars=1, resizable=1, width=800, height=600");
      if (w.opener == null)
        w.opener = self;
        w.focus();
  }

   function build_params() 
  {
    var lparms;
    lparms = '';
    lparms = lparms + '&p_incorrect=' + $x('P212_INCORRECT').value; 
    lparms = lparms + '&p_correct=' + $x('P212_CORRECT').value;

    return lparms;
  }
Text in textarea:
035 5768 06/15/2010
035 5768 06/16/2010
035 5768 06/17/2010

Printout on report:
035 5768 06/15/2010035 5768 06/16/2010035 5768 06/17/2010
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2010
Added on Jun 18 2010
2 comments
1,482 views