Code problem - SQL Developer

Asked

Viewed 61 times

1

The following tables present 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)
);

the referenced tables exist and are working perfectly. I commented to fk to see if there was an error there, but the problem persists. Follow the error:

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

of the second table:

Error report - ORA-00904: "MOD_ARM_NOME": invalid Identifier 00904. 00000 - "%s: invalid Dentifier"

  • I tested your code here and it worked smoothly.

  • Either you take the quotation marks off everything or keep the quotation marks on everything.Check it out. I bet you what’s going wrong is the quotation marks. rsrs

  • It doesn’t work here.. and it’s exactly the same code, I copied and pasted!

  • Ever tried to run Sqlplus? It seems to me some configuration of Sqldeveloper.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.