Skip to main content
E
emacaco
Participant
November 3, 2008
Question

Oracle CLOB Output Problem

  • November 3, 2008
  • 1 reply
  • 662 views
I'm trying to output the results of a query which returns a CLOB from an oracle database. If I just use cfoutput on it I get something like oracle.sql.CLOB@73cfe2 which obviously isn't useful to me. After searching the internet for answers I came across several people who suggested creating a java.lang.String object and passing my CLOB into the init method but that resulted in an error "Unable to find a constructor for class java.lang.String that accepts parameters of type ( oracle.sql.CLOB )." At this point I'm at a loss and don't know what to do. It seems like such a simple issue but I can't figure it out. Any help would be appreciated.

I'm running version 7,0,0,91690 on Windows 2003.

Thanks
    This topic has been closed for replies.

    1 reply

    A
    Anonymous
    April 3, 2009
    This is a technique that works with CF version 8,0,0,176276

    <cflayoutarea title="Description" name="Description" style="height:100%">
    <cfoutput query="get_description">
    <cftextarea richtext=true height="400" width="950" wrap=hard name="DESCRIPTION" tabindex="10">#get_description.DESCRIPTION#</cftextarea>
    </cfoutput>
    </cflayoutarea>

    You said that you are using CF 7, so you can't use the richtext option out-of-the-box. But cftextarea might do what you want.
    Scott
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices