SQL Language (MOSC)

MOSC Banner

ORA-01735 when creating a check constraint with EXCEPTIONS INTO clause

edited Dec 18, 2013 9:32PM in SQL Language (MOSC) 8 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center