Search notes:

ORA-02438: Column check constraint cannot reference other columns

create table tq84_ora_02438 (
   a  number,
   b  number  check ( a+b > 42 )
);

Better:

create table tq84_ora_02438 (
   a  number,
   b  number,
   --
   check ( a+b > 42 )
);

Typos

This error is also thrown when a non-existing column is specified in the check constraint, for example because of a typO:

create table tq84_ora_02438 (
  col_one    number(1) not null check (col_one   between 1 and 5),
  col_two    number(1) not null check (col_tow   between 3 and 7), -- Note the typo (col_tow)
  col_three  number(1) not null check (col_three between 2 and 8)
);

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206439, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-02438_Column-check-constraint-cannot-reference-other-columns(60): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

ORA-02438: Column check constraint cannot reference other columns

Typos

See also