ORA-00904: "OBJECT_VALUE": invalid identifier

OBJECT_VALUE is the pseudocolumn for xmltype. Its also called as sys_nc_rowinfo$.

It only works if you create a table of xmltype



Note that, when you use select * from, the colum name is called SYS_NC_ROWINFO$



Alternativley, you can get the column using object_value pseudo column.


If you create the same table in a different way, OBJECT_value will not work