RE: limit on number of tables in join

I've run across an unusual bug (4204878/ 3765373/ 3004824) on Oracle 9.2.0.5. When more than 22 ANSII joins are done in a select statement, an ORA-01445 occurs. According to Support:

"1- One solution is to rewrite the query to not use ANSI joins.=20 2- Rewrite the join queries with fewer exposed columns, either by declaring named views with only relevant columns, or by using inlined subqueries with only relevant columns."

Of course, if you use less than 22 ANSII joins, the bug does not manifest.

-Brian

--
http://www.freelists.org/webpage/oracle-l