CODEWITHSUNDEEP
sqldatabaseplsql
matyyyy
matyyyy

Reputation: 387

Oracle: SQL command not properly ended

After invoking this line of code:

EXECUTE IMMEDIATE 'ALTER TABLE user.table DISABLE CONSTRAINT user.trigger;';

I receive an error:

ORA-00933 SQL Command not properly Ended

Upvotes: 0

Views: 2472

Answers (1)

socha23
socha23

Reputation: 10239

Try dropping the semicolon in statement to be executed:

EXECUTE IMMEDIATE 'ALTER TABLE user.table DISABLE CONSTRAINT user.trigger';

Upvotes: 1

Related Questions