This discussion is archived
3 Replies Latest reply: Nov 5, 2012 4:50 AM by zooid RSS

display clob column with htp package

Gor_Mahia Explorer
Currently Being Moderated
All,
I need help with displaying clob column data in dynamic content with any appropriate package but iam currently using htp.p it seems not to work well. Some of my clob values are so big like length>=18000 but when i use htp.p all output text is pulled together without any line break but i want data to be displayed AS IS stored in the table column.....any help is appreciated thanks.
  • 1. Re: display clob column with htp package
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    I think you can diisplay maximum 32767 characters. You will need to replace CHR(13) and CHR(10) with
    in order to get it displayed as you want.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.apress.com/9781430235125
    http://apex.oracle.com/pls/otn/f?p=31517:1
    http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
    -------------------------------------------------------------------
  • 2. Re: display clob column with htp package
    Gor_Mahia Explorer
    Currently Being Moderated
    Denes,
    You got it immediately after i posted this question that's what i did/chr(13) and worked perfect. Thank you and have a wonderful weekend
  • 3. Re: display clob column with htp package
    zooid Newbie
    Currently Being Moderated
    Hi jieri,

    I am looking for a solution where my apex application will download to file on the client pc the content of a clob which happens to be xml. I noticed you mention in your post that you have managed this for multiple files. Could you point me in the right dirrection on this subject pleasse.

    Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points