Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: An Oracle bug?

Re: An Oracle bug?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 15 Sep 2007 07:25:22 +0200
Message-ID: <46eb6cc0$0$15265$426a74cc@news.free.fr>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US