Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query in 10g

Re: Query in 10g

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 8 Nov 2006 14:40:43 +0000
Message-ID: <7765c8970611080640w7cea126aif27a421e0b16b8ad@mail.gmail.com>


explain plan the two different queries.

On 11/8/06, crcbedoy_at_proteccion.com.co <crcbedoy_at_proteccion.com.co> wrote:
>
> Nop, the same error appears:(
>
> Isabel Bedoya Gómez
> Gestión de Tecnología
> Tel. 2307500 ext: 4077
> [image: Inactive hide details for "LS Cheng" <exriscer_at_gmail.com>]"LS
> Cheng" <exriscer_at_gmail.com>
>
>
>
> *"LS Cheng" <exriscer_at_gmail.com>*
>
> 08/11/2006 09:20
>
>
> Para
>
> crcbedoy_at_proteccion.com.co
> cc
>
> oracle-l_at_freelists.org
> Asunto
>
> Re: Query in 10g
> may be you should try
>
> emp_codigo = '43103973'
>
>
> regards
>
>
> On 11/8/06, *crcbedoy_at_proteccion.com.co * <crcbedoy_at_proteccion.com.co><*
> crcbedoy_at_proteccion.com.co* <crcbedoy_at_proteccion.com.co>> wrote:
>
> Hi List!!!
>
>
> I have a question, do you ever have to come that while running
> a query in 10g you get the following error:
>
> select ACUM_PERIODO,con_nombre, ACUM_UNIDADES || ' ' ||
> DESC_UNIDAD desc_unidad, pec_saldo_valor, acum_valor_local from
> VRH_PRO_ACU_COL_PAG WHERE emp_codigo = 43103973 and ACUM_ANO = 2006 and
> acum_mes=9
> /
>
> ERROR:
> ORA-01722: invalid number
>
>
> The table description is:
>
>
> Name Null Type
> ------------------------------ --------
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> EMP_CODIGO VARCHAR2(11)
> EN1_CODIGO NUMBER(4)
> ACUM_ANO NUMBER(4)
> ACUM_MES NUMBER(2)
> ACUM_PERIODO NUMBER(1)
> ACUM_FECHA_PAGO DATE
> CON_CODIGO NUMBER(4)
> CON_NOMBRE VARCHAR2(30)
> ACUM_UNIDADES NUMBER(8,3)
> CON_UNIDAD_MEDIDA VARCHAR2(3)
> DESC_UNIDAD VARCHAR2(60)
> CON_NATU VARCHAR2(3)
> ACUM_VALOR_LOCAL NUMBER(12,2)
> PROC_CODIGO NUMBER(3)
> PEC_SALDO_VALOR NUMBER
>
>
> When I delete the "and acum_mes=9" it works, but when I run
> the query with it, it gives me the error: ORA-01722: invalid number. Do you
> have any idea what can be the problem?.. it was running perfectly in 9i:(
>
>
> Thanks in advance,
>
> Isabel Bedoya Gómez
> Gestión de Tecnología
> Tel. 2307500 ext: 4077
>
>
>
> _______________________________________________________________________________
> Este correo y cualquier archivo anexo pertenecen a PROTECCION
> S.A. y son para uso exclusivo del destinatario intencional.
> Esta comunicacion puede contener informacion confidencial o de acceso
> privilegiado. Si usted ha recibido este correo por error, equivocacion u
> omision favor notificar en forma inmediata al remitente y eliminar dicho
> mensaje con sus anexos. La utilizacion, copia, impresion, retencion,
> divulgacion, reenvio o cualquier accion tomada sobre este mensaje y sus
> anexos queda estrictamente prohibida y puede ser sancionada legalmente.
>
> This e-mail and any attached files belong to PROTECCION S.A.
> and they are for the sole use of the intended recipient(s). This
> communication may contain confidential or privileged information. If you are
> not the intended recipient, please contact the sender by reply this e-mail
> and destroy all copies of the original message. Any unauthorised review,
> use, disclosure, dissemination, forwarding, printing or copying of this
> email or any action taken in reliance on this e-mail is strictly prohibited
> and may be unlawful
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info



-- http://www.freelists.org/webpage/oracle-l

ecblank.gif graycol.gif
Received on Wed Nov 08 2006 - 08:40:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US