Oracle10g inview bugs

Folks,

We're encountering a series of bugs related to Oracle's handling of inline views in Oracle10g. The first one resulted in an ORA-600, which was worked-around by setting _complex_view_merging = false.

This one, however, doesn't error, but rather returns inconsistent results depending on the way the where clause is structured.

For example

update foo set (bar, baz) = ( select a, b from ... ) where foo_id in ( select foo_id from ... )

returns an error "cannot set FOO.BAR to NULL" for example. However, if I run the where clause query:

    select foo_id from ...

and get back its result (which is a single ID, say "1"), and then use that result in

update foo set (bar, baz) = ( select a, b from ... ) where foo_id = 1

it works.

Has anyone else run into this?

Adam

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