Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error with CLOB
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_at_x.washington.edu (replace x with u to respond)Received on Mon Aug 08 2005 - 13:31:12 CDT