I will try it, thanks ;)
<ctcgag_at_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:20020929180930.176$HG_at_newsreader.com...
> "Mantat" <mtlam_at_macau.ctm.net> wrote:
> > Hello,
> >
> > i have inserted some texts (about 5000 chars) into a CLOB column in a
> > table, when i use sqlplus or sqlplus worksheet to retrieve that column,
> > an error message appear and i can read that column,
> > how can i retrieve it?
>
> I do 'select dbms_lob.substr(lob_column), blah blah '
>
> There may be other/better ways.
>
> Xho
>
> --
> -------------------- http://NewsReader.Com/ --------------------
> Usenet Newsgroup Service
Received on Mon Sep 30 2002 - 07:49:34 CDT
