Search notes:

ORA-32625: illegal dimension in cell reference predicate

Preparation:
create table tq84_ora_32625 (
   dim   char(1),
   m_1   number,
   m_2   number
);

begin

   insert into tq84_ora_32625 values ('A',  100,  4);
   insert into tq84_ora_32625 values ('B',  200,  8);
   insert into tq84_ora_32625 values ('C', -300,  7);
   insert into tq84_ora_32625 values ('Y',  -17,  6);
   insert into tq84_ora_32625 values ('Z',   22,  5);

   commit;
end;
/
The following statement runs ok:
select
   *
from
   tq84_ora_32625 model
   dimension by (dim)
   measures     (m_1, m_2)
  (
     m_1[dim > 'Q'] = null
   )
;
--
-- D        M_1        M_2
-- - ---------- ----------
-- A        100          4
-- B        200          8
-- C       -300          7
-- Y                     6
-- Z                     5
The following statement references a measure where a dimension was expected, thus ORA-32625: illegal dimension in cell reference predicate is thrown:
select
   *
from
   tq84_ora_32625 model
   dimension by (dim)
   measures     (m_1, m_2)
  (
     m_2[m_1 < 0] = null
  )
;
Cleaning up:
drop table tq84_ora_32625;

See also

Other Oracle error messages

Index

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:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759406387, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-32625_illegal-dimension-in-cell-reference-predicate(91): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51