ORA-01735 when creating a check constraint with EXCEPTIONS INTO clause
Hallo,
as a developer I try a new concept using exception tables for constraints on a 10gR2 database. So I created a exception table analog to that in the utlexcpt.sql
create table exceptions_bad_status(row_id rowid,
owner varchar2(30),
table_name varchar2(30),
constraint varchar2(30));
On my table "MyTab" I would create a check constraint for the status column. But when I execute the following statement
I get "ORA-01735: invalid ALTER TABLE option"
ALTER TABLE MyTab ADD CONSTRAINT
ck_status CHECK ( status BETWEEN 41 AND 71)
INITIALLY DEFERRED
DEFERRABLE
ENABLE NOVALIDATE
EXCEPTIONS INTO exceptions_bad_status;
I found really nothing helpful in metalink nor on this community. Oracle 10gR2 Documentation is not helpful as well.
as a developer I try a new concept using exception tables for constraints on a 10gR2 database. So I created a exception table analog to that in the utlexcpt.sql
create table exceptions_bad_status(row_id rowid,
owner varchar2(30),
table_name varchar2(30),
constraint varchar2(30));
On my table "MyTab" I would create a check constraint for the status column. But when I execute the following statement
I get "ORA-01735: invalid ALTER TABLE option"
ALTER TABLE MyTab ADD CONSTRAINT
ck_status CHECK ( status BETWEEN 41 AND 71)
INITIALLY DEFERRED
DEFERRABLE
ENABLE NOVALIDATE
EXCEPTIONS INTO exceptions_bad_status;
I found really nothing helpful in metalink nor on this community. Oracle 10gR2 Documentation is not helpful as well.
0