Re: retrieve CLOB column in SQLPlus

In article <an6mgr$5e14_at_ctmsun0.macau.ctm.net>, "Mantat" says...
>
>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?
>
>THx.
>
>

crystal ball is in the shop. Therefore we cannot actually see your error message. Could you post it (along with versions and so on).

You'll need to

SQL> set long 5000

to see upto 5000 chars of the clob (defaults to 80 or something small like that) by the way.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp