Database Error Ora 00904

general discussion
1

Hi all

Im encountering a strange problem here.

Im using two objects from 2 tables. The query runs fine when I run it selecting one object, but when I select both, it returns an Error Database Error Ora 00904 - Invalid Identifier…

Any Ideas ? :hb:

bulgaru10 :malta: (BOB member since 2006-12-15)

2

Sounds like your join isn’t correct, check the join definition.

cashworth (BOB member since 2005-02-09)

3

The join is a simple one to many directly between the two tables

bulgaru10 :malta: (BOB member since 2006-12-15)

4

If you can query both objects individually, but you get that error when selecting both and initiating the join, it still points to me like there is a problem with the join definition.

Can you run the generated SQL correctly in TOAD etc?

cashworth (BOB member since 2005-02-09)

5

you are probably right but what could be wrong with the join ?

i have a fact table which is joined to 2 dim tables, and the objects are coming one from each dim table

bulgaru10 :malta: (BOB member since 2006-12-15)

6

Hi,

Can you post the query that BO generates?

By the way, what database do you use?

Marek Chladny :slovakia: (BOB member since 2003-11-27)