Re: get complete CLOB

From: Jan Korecki <Jan.Korecki_at_contactor.se>
Date: Mon, 17 Nov 2003 14:57:06 +0100
Message-ID: <3fb8d3e4$0$97834$57c3e1d3@news3.bahnhof.se>

Hello!

set long 32000

"SQL*Plus by default only shows the first 80 bytes of any LONG, CLOB and NCLOB datatypes."

http://www.orafaq.com/faqplus.htm

Regards,
Janne!

RAYmond RICHard wrote:

> Hello,
>
> I'm trying to recive a CLOB-field with a batchscript:
>
> set echo off
> set feedback off
> set heading off
> set verify off
>
> spool Mailtext.txt
> select MAILBODY
> from FT_CUSTOMERGROUPS
> where CUSTOMERGROUP = '&1';
> spool off
> quit
>
>
> But I only get the first vew lines of the whole text in it. Is there
> anything wrong with my statement? And if yes, how can I make it work?
>
> Regards
> RAY
Received on Mon Nov 17 2003 - 07:57:06 CST