DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: htp.prn does not write CR or lineshift

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    htp.prn does not write CR or lineshift

    We have just migrated from 9.X to 10.X and changed from Unix to Windows enviroment. However our PL/SQL pages are not behaving as before.

    Our procedures processes files created on windows enviroment, and they therefore contain the 1310 CR/LS, however when doing a htp.prn they are not returned the browser.

    Using htp.print does output the 1310, but htp.print is not usable in our application.

    Any suggestions?

    PS: Sorry for my poor english skills

  2. #2
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    Can you just concatenate the carriage return and line feed characters to the string?

    You could define your own "print" procedure that does the concatenation. Otherwise, you would have to do it for each and every call to htp.prn. Something like:

    procedure myPrint (pi_string in varchar2)
    is
    crlf char(2) := chr(13) || chr(10);
    begin
    htp.prn(mystring || crlf);
    end myPrint;


    And then in your plsql page:

    myPrint('Hello World');

    should give you the same as

    htp.print('Hello World');

    hth,
    Pete
    ____________________
    Pete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width