Problem in code - SQL Developer

0

The following tables have an error:

CREATE TABLE REQ_ROB_EQP ( 
    REQ_PER_ROB_ID NUMBER,
    REQ_EQU_NOME VARCHAR(100),    
    CONSTRAINT REQ_ID_NOME_PK PRIMARY KEY (REQ_PER_ROB_ID, REQ_EQU_NOME)
    --CONSTRAINT REQ_PER_ROB_ID_FK FOREIGN KEY (REQ_PER_ROB_ID) REFERENCES ROB_ROBOTICO(ROB_PER_ID),
    --CONSTRAINT REQ_EQU_NOME_FK FOREIGN KEY (REQ_EQU_NOME) REFERENCES EQU_EUIPAMENTO(EQU_NOME)
);

CREATE TABLE MOD_ARM_FOR ( 
    MOD_ARM_NOME VARCHAR(100), 
    MOD_FOR_MODELO VARCHAR(100),    
    CONSTRAINT MOD_NOME_MODELO_PK PRIMARY KEY (MOD_ARM_NOME, MOD_FOR_MODELO),
    CONSTRAINT MOD_ARM_NOME_FK FOREIGN KEY (MOD_ARM_NOME) REFERENCES ARM_ARMA(ARM_NOME),
    CONSTRAINT MOD_FOR_MODELO_FK FOREIGN KEY (MOD_FOR_MODELO) REFERENCES FOR_FORMA(FOR_MODELO)
);

Referenced tables exist and are working perfectly. I even commented on fk to see if it was a bug there, but the problem persists. Here is the error:

  

Error report - ORA-00904: "REQ_PER_ROB_ID": invalid identifier   00904. 00000 - "% s: invalid identifier"

from the second table:

  

Error report - ORA-00904: "MOD_ARM_NAME": invalid identifier   00904. 00000 - "% s: invalid identifier"

    
asked by anonymous 03.12.2018 / 11:34

0 answers