Oracle SQL-ALTER TABLE Error

Question

I've been looking over the following SQL code for awhile and just can't seem to find the problem. I'm relatively new to SQL, so I'm sure it's just something I'm overlooking. The error message I get is: ORA-01735: Invalid ALTER TABLE option.

Code:

ALTER TABLE PATIENT
(
ADD CONSTRAINT PProfileForeignKey
    FOREIGN KEY (pProfileID) REFERENCES PATIENT_PROFILE(Profile_ID),
ADD CONSTRAINT InsForeignKey
    FOREIGN KEY (pInsID) REFERENCES INSURANCE(Insurance_ID)
        ON DELETE SET NULL
);

I have triple checked to make sure the foreign key column names and the referenced column names are correct.

Can you specify multiple Foreign Keys in a single ALTER TABLE statement? Try splitting it in two... — dnoeth
– dnoeth, Commented Mar 27, 2016 at 16:37

ScaisEdge · Accepted Answer · 2016-03-27 16:49:19Z

1

seems The parentheses are in wrong place

ALTER TABLE PATIENT
 ADD (CONSTRAINT PProfileForeignKey
    FOREIGN KEY (pProfileID) REFERENCES PATIENT_PROFILE(Profile_ID),
    CONSTRAINT InsForeignKey
    FOREIGN KEY (pInsID) REFERENCES INSURANCE(Insurance_ID)
        ON DELETE SET NULL);

edited Mar 27, 2016 at 16:49

answered Mar 27, 2016 at 16:41

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Zarch Over a year ago

Correction, if you saw my first comment. This did work on another ALTER TABLE, I must have done something wrong the first time. Thank you!

ScaisEdge Over a year ago

@Zarch thank you very much ... I was sure that would work

Collectives™ on Stack Overflow

Oracle SQL-ALTER TABLE Error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related