Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Brazil
    Posts
    59

    Unanswered: Error While executing a simple script

    Hi,

    I am trying to run the following simple script in Oracle 8i:

    UPDATE
    vcad_ocorrencias
    set tipo_situa_solic = 'E', desc_obs_atendente = 'ACERTO DE BASE -
    18/10/2004'
    where cod_solicitacao = 7
    and tipo_situa_solic in ('N', 'P')
    and cod_contrato_Inter not in ( 2247,2295,2296,2297,2278,2269,2168)
    and dthora_geracao < '07/10/2004'
    order by cod_contrato_inter;

    And it is returning the following message error:

    ERRO na linha 8:
    ORA-00933: SQL command not properly ended

    Well this script was made by a developer and now I have to run it in production environment...
    Does someone know why it is failing?
    Nadia

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Drop the "ORDER BY" - it has no place in an UPDATE statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •