SQL & PL/SQL

Hi All,

I am using oracle 9i enterprise edition. I am facing an issue with using TO_CLOB in SELECT query. Could anyone share with me the details why the qery is not returning the full string and it trims the value and reruns as below.

select 'X' || to_CLob('gvsjigfjdshgfjsdhgfdsh' || 'gvsjigfjdshgfjsdhgfdsh' || 'gvsjigfjdshgfjsdhgfdsh'|| 'gvsjigfjdshgfjsdhgfds

h'|| 'gvsjigfjdshgfjsdhgfdsh'|| 'gvsjigfjdshgfjsdhgfdsh'|| 'gvsjigfjdshgfjsdhgfdsh'|| 'gvsjigfjdshgfjsdhgfdsh'|| 'gvsjigfjdshgfjsdhg

fdsh') from dual;

Result:

Xgvsjigfjdshgfjsdhgfdshgvsjigfjdshgfjsdhgfdshgvsjigfjdshgfjsdhgfdshgvsjigfjdshgf

When I am try to spool the records, I could see the records are not spooled as expected and the complete output is not visible. I tried increasing the linesize and page size in SQL editor. But still it returns the same output. Is there a way to get the full string after using the TO_CLOB in SQL.

Thanks

Ramkumar