ORA-01468 problem

[ziggs]

We are changing programs and our existing system uses Oracle 7.3 and the new system uses Oracle 8i. The new database for the program is somewhat similar to before with some changes (some tables and fields renamed and/or added). I have several Crystal Reports on the old database, but some of them are having problems in the new DB. FYI, both ODBC connections are set to use the Microsoft ODBC for Oracle.

I'll use an example of an existing report to explain. I have four tables that I'm collecting data from. Three of the tables are linked to the primary table and are linked by a common field called CaseNumber. For the three tables I have a outer join to the primary table. This works in the Oracle 7.3 DB just fine. However, the same linkage in the new 8i DB causes the following error:

ODBC error:[Microsoft][ODBC driver for Oracle][Oracle]ORA-01468: a predicate may reference only one outer-joined.

Looking up this error message, it says to only use one outer join. However, I'm puzzled as to why I can use three outer joins on the Oracle 7.3 database.

Now, if I only set one of the three tables with an outer join, the report works. However, I don't get all the records that I need.

Am I missing something here? Any help would be appreciated. I can pass on more infomation if needed. I tried to keep this message as short as possible.

 

[sem]

You may have 3 outer joins but with 1 table. Check whether your (+) is in the right place.