PL / SQL: ORA-00922: Option not found or invalid

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
Alessandro Y
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Mon, 19 Aug 2013 10:24 am

Good morning

I am a beginner in Oracle and I need the help of you, no matter how simple questions seem. I am validating the creation of a script via SQL Plus and and the following errors appears below:

Select all

LINE/COL	ERROR 
3/5			PL/SQL: SQL Statement ignored 
3/9			PL/SQL: ORA-00922: opção não encontrada ou inválida
What am I wrong?

Select all

CREATE OR REPLACE TRIGGER "TG_TESTES" 
BEFORE UPDATE ON "TABELA_X" 
BEGIN 
  IF (old.CAMPO_X = new.CAMPO_X) THEN 
    SET new.CAMPO_X = "F"; 
  END IF; 
END; 
/

Thanks for any tip

ATT

ALESSANDRO
Alessandro Y
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Mon, 19 Aug 2013 10:24 am

Personnel,

Some syntaxes were incomplete or inadequate. I was able to adjust. Topic closed.

ATT

Select all

CREATE OR REPLACE TRIGGER "TG_TESTES" 
BEFORE UPDATE ON "TABELA_X" 
FOR EACH ROW 
BEGIN 
IF (:OLD.CAMPO_X = :NEW.CAMPO_X ) THEN 
:NEW.minerado := 'F'; 
END IF; 
END; 
/
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests