Re: Query in 10g

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: crcbedoy@xxxxxxxxxxxxxxxxx
  • Date: Wed, 8 Nov 2006 14:40:43 +0000

explain plan the two different queries.

On 11/8/06, crcbedoy@xxxxxxxxxxxxxxxxx <crcbedoy@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx>]"LS
Cheng" <exriscer@xxxxxxxxx>



    *"LS Cheng" <exriscer@xxxxxxxxx>*

            08/11/2006 09:20


Para

crcbedoy@xxxxxxxxxxxxxxxxx
cc

oracle-l@xxxxxxxxxxxxx
Asunto

Re: Query in 10g
may be you should try

emp_codigo = '43103973'


regards


On 11/8/06, *crcbedoy@xxxxxxxxxxxxxxxxx * <crcbedoy@xxxxxxxxxxxxxxxxx><*
crcbedoy@xxxxxxxxxxxxxxxxx* <crcbedoy@xxxxxxxxxxxxxxxxx>> 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

GIF image

GIF image

Other related posts: