Help with REF

Hallo

i try a simple for Row Objects in O8.0.4:

create type TMESSWERT as object (Time DATE,Value NUMERIC(10,2)); create table MESSWERTE of TMESSWERT;
insert into MESSWERTE values (sysdate,10.2);

this all works fine. But

select REF(M) from MESSWERTE M where Value = 10.2;

yields a
ORA-00932: inconsistent datatypes

What am I doing wrong? Please help me!

Thanks Helmut Received on Mon Dec 28 1998 - 10:07:44 CST