Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: An Oracle bug?
<lyle.chen_at_gmail.com> a écrit dans le message de news: 1189821430.467816.22710_at_g4g2000hsf.googlegroups.com...
| When running the following query on Ora10.2.0.3 32bits Win., I got a
| ORA-00904 error, which said "BB"."S" is not a valid identifier.
|
| with a as ( select 'x' r, 'x' t from dual ),
| b as ( select 'x' s, 'x' t from dual)
| select ( select 'x'
| from ( select r
| from a
| where a.t = ( select b.t
| from b
| where b.s = bb.s )))
|
| from b bb;
|
| However, if I try it on the 64bits version 10.2.0.1, it works. I need
| to keep those scripts (many queries have the same form as the
| simplified one) working on both platform. I've tried three days to
| work around this problem, but failed in the end. :-(
|
| How can I work around it? Help~
|
Not a bug, a limitation, bb is known only at the first sublevel and not the subsequent ones.
Regards
Michel Cadot
Received on Sat Sep 15 2007 - 00:25:22 CDT