How can i add foriegn key in nested table ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How can i add foriegn key in nested table ?

this is my code ALTER TABLE vac_nt ADD CONSTRAINT VAC FOREIGN KEY (ID_VaccinationCenter) REFERENCES vac_nt(ID_VaccinationCenter); this is Error report - ORA-30730: referential constraint not allowed on nested table column 30730. 00000 - "referential constraint not allowed on nested table column" *Cause: An attempt was made to define a referential constraint on a nested table column. *Action: Do not specify referential constraints on nested table columns.

27th Apr 2021, 12:34 PM
Mimi
Mimi - avatar
1 Answer
+ 1
The error message indicated you were using Oracle, so for the sake of context clarity, please tag Oracle or PLSQL rather than MySQL ☝
27th Apr 2021, 1:18 PM
Ipang