Re: displaying CLOB fields
From: Business <ihatespam_at_nomail.com>
Date: Wed, 14 Mar 2001 15:47:51 -0500
Message-ID: <98okln$1ihj$1_at_msunews.cl.msu.edu>
Date: Wed, 14 Mar 2001 15:47:51 -0500
Message-ID: <98okln$1ihj$1_at_msunews.cl.msu.edu>
If your clob data is always less than 32k-1 bytes, you can write a stored proc to pass back the data in a VARCHAR2 and display the parameter value. If the clob is part of a cursor, you will have to break the clob into pieces using the DBMS_LOB.substr function.
"Fadi" <fsaff_at_hotmail.com> wrote in message
news:3AAFB5CF.D0B1F4B5_at_hotmail.com...
>
> Hello,
>
> Is it possible to display the contents of a Clob field in a
> TextAreaControl component?
>
> I tried using .setDataItemName(...) but that displays:
>
> oracle.sql.CLOB_at_53abbb
>
> I'm using TextAreaControl (oracle) component to display the contents of
> the field..
>
> any help would be appreciated,
>
> Thank you,
>
> Fadi
>
Received on Wed Mar 14 2001 - 21:47:51 CET