Error with CLOB

From: daniellopez21 <daniellopez21_at_gmail.com>
Date: 8 Aug 2005 00:24:11 -0700
Message-ID: <1123485851.558248.279620@g14g2000cwa.googlegroups.com>

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 Received on Mon Aug 08 2005 - 02:24:11 CDT