Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-08005:specified row does not exist

user9211248Dec 31 2013 — edited Dec 31 2013

Hi All,

I have sql query created using 2 dimensions and 1 fact table. Below is the Psuedo query

SELECT COUNT (*)

FROM

    DIMTABLE1 D1,

    DIMTABLE2  D2,

    FACT1 F1

WHERE   D1.ITEM_ID = F1.ITEM_ID

             AND D2.ORGANIZATION_ID = F1.INVENTORY_ID

The query is giving result when select * is used, but its throwing ORA-08005 error when count (*) is used.

Can someone please help.

Thanks,

Prathibha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 28 2014
Added on Dec 31 2013
3 comments
8,728 views