|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by hernst42 in Oracle Database
I get thefollowing error when running the following select. I google around and found that I need to cast something to get ridd of the errror, but I was unable to find how. Anyone know what I need to do?
ORA-22905: cannot access rows from a non-nested table item Offset: 38
select v0."PK" from b0 v0 inner join TABLE (select max(t0."PK") as "PK" from b0 t0 where t0."EditTime" <= 1234567890 group by t0."LK" ) tt0 on (tt0."PK"=v0."PK")
SQL> describe b0;
Name Null? Type
--------------------------
----------
----- -------- --------------------------
--
PK NOT NULL NUMBER
LK NOT NULL NUMBER
kzStatus NOT NULL CHAR(1)
histtop NOT NULL CHAR(1)
FirstEditor NOT NULL NUMBER
FirstEditTime NOT NULL NUMBER
Editor NOT NULL NUMBER
EditTime NOT NULL NUMBER
20091111-EE-VQP-91 - Hierarchy / EE_QW_EXPERT_20070906