Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "daniellopez21" <daniellopez21@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Error with CLOB
Date: 8 Aug 2005 00:24:11 -0700
Organization: http://groups.google.com
Lines: 70
Message-ID: <1123485851.558248.279620@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 80.58.32.109
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123485855 13364 127.0.0.1 (8 Aug 2005 07:24:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 07:24:15 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=80.58.32.109;
   posting-account=1cH-bA0AAAAflTRSEGWxUbcedhjOut5m
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249064

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