Re: retrieve CLOB column in SQLPlus

"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