[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.

10/19/2009 at 02:44AM PDT, ID: 24822969 | Points: 500
[x]
Attachment Details

ORA-22905: cannot access rows from a non-nested table

Asked by hernst42 in Oracle Database

Tags: oracle

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
[+][-]10/19/09 02:56 AM, ID: 25603798

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/19/09 03:55 AM, ID: 25604048

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/19/09 04:49 AM, ID: 25604273

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/19/09 05:48 AM, ID: 25604646

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_EXPERT_20070906