Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-hog.berkeley.edu!newsfeed.berkeley.edu!ucberkeley!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@psoug.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: Error with CLOB
Date: Mon, 08 Aug 2005 11:31:12 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1123515063.291480@yasure>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <1123485851.558248.279620@g14g2000cwa.googlegroups.com>
In-Reply-To: <1123485851.558248.279620@g14g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@67.136.137.87
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 78
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249103

daniellopez21 wrote:
> I am receiving an ORA-00932: inconsistent datatypes: expected CLOB -
> got CHAR
> 
> My spool select, is this:
> 
> WHENEVER SQLERROR EXIT SQL.SQLCODE
> 
> SET ECHO OFF
> SET VERIFY OFF
> SET TERMOUT OFF
> TTITLE OFF
> SET HEADING OFF
> SET FEEDBACK OFF
> SET FLUSH OFF
> SET PAGESIZE 50000
> SET LINESIZE 32
> SET NEWPAGE NONE
> SET SPACE 0
> 
> spool off
> 
> SET TERMOUT ON
> PROMPT Extrayendo ABONADOS_CMT_112
> SET TERMOUT OFF
> 
> SET LINESIZE 9965
> SPOOL $HOME/CARGA/ABONADOS_CMT_112.TXT
> SELECT
> RPAD(NVL(TO_CHAR(mp.COD_ABONADO_CABLE),' '),8,' '),
> RPAD(NVL(TO_CHAR(ab.COD_PUNTO_SERVICIO),' '),20,' '),
> RPAD(NVL(TO_CHAR(ab.CONMODIF),' '),1,' '),
> RPAD(NVL(ab.ABNOMB_TIT,' '),50,' '),
> RPAD(NVL(SUBSTR(ab.ABAPELL1_TIT,1,50),' '),50,' '),
> RPAD(NVL(ab.ABAPELL2_TIT,' '),50,' '),
> RPAD(NVL(ab.ABDNI_TIT,' '),20,' '),
> RPAD(NVL(ab.ABNOMB_USU,' '),50,' '),
> RPAD(NVL(ab.ABAPELL1_USU,' '),50,' '),
> RPAD(NVL(ab.ABAPELL2_USU,' '),50,' '),
> RPAD(NVL(ab.ABDNI_USU,' '),20,' '),
> RPAD(NVL(ab.ABCOMER,' '),50,' '),
> RPAD(NVL(ab.ABTVIA,' '),5,' '),
> RPAD(NVL(ab.ABCALLE,' '),80,' '),
> RPAD(NVL(SUBSTR(ab.ABNUM,1,7),' '),7,' '),
> RPAD(NVL(SUBSTR(ab.ABPORTAL,1,50),' '),4,' '),
> RPAD(NVL(ab.ABESCA,' '),10,' '),
> RPAD(NVL(ab.ABPISO,' '),10,' '),
> RPAD(NVL(ab.ABPUERT,' '),10,' '),
> RPAD(NVL(TO_CHAR(ab.CVIA),' '),5,' '),
> RPAD(NVL(TO_CHAR(ab.CPSVIA),' '),5,' '),
> RPAD(NVL(ab.DPSVIA,' '),50,' '),
> RPAD(NVL(TO_CHAR(ab.TINUM),' '),1,' '),
> RPAD(NVL(ab.EIN,' '),5,' '),
> RPAD(NVL(ab.ESN,' '),5,' '),
> RPAD(NVL(TO_CHAR(ab.ABPOST),' '),5,' '),
> RPAD(NVL(TO_CHAR(ab.ABPOBL),' '),50,' '),
> RPAD(NVL(TO_CHAR(ab.CPOB),' '),12,' '),
> RPAD(NVL(ab.ABPROVIN,' '),30,' '),
> RPAD(NVL(ABTELF1,' '),4000,' '),
> RPAD(NVL(ABTELF2,' '),4000,' '),
> RPAD(NVL(ABINFO,' '),250,' '),
> RPAD(NVL(ABTERM,' '),1000,' '),
> RPAD(NVL(TO_CHAR(COD_ERROR),'1'),2,' ')
> FROM SGI_AC_ABONADOS_CMT_112 ab, SGI_AC_CLIENTES_MP mp
> WHERE ab.COD_ABONADO IS NOT NULL
> AND ab.cod_abonado = mp.cod_abonado;
> 
> spool off
> 
> exit

And your Oracle version number is?
And the data types of the columns are?
-- 
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)