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.
– Reginaldo Rigo
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
– Reginaldo Rigo
It doesn’t work here.. and it’s exactly the same code, I copied and pasted!
– dani
Ever tried to run Sqlplus? It seems to me some configuration of Sqldeveloper.
– Reginaldo Rigo