On Sep 15, 4:12 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <lyle.c..._at_gmail.com> a écrit dans le message de news: 1189843183.704877.185..._at_r29g2000hsg.googlegroups.com...
> On Sep 15, 1:25 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>
>
>
> > <lyle.c..._at_gmail.com> a écrit dans le message de news: 1189821430.467816.22..._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
>
> Thank you, Michel!
>
> However, as I found, on 64bits Oracle database, the limitation seems
> disappeared. So, I wonder if some adjustments on 32bits Oracle
> database can help me work around this problem (at least, weaken the
> limitation)?
>
> -------------------------
>
> No it is in 64-bit but a 10.2.0.1 bug fix in the next patchset.
> I had this discussion AskTom 2 years ago.
> see:http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4...http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4...http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4...
>
> Regards
> Michel
Thank you very much, Michel. The links you provided really help me a
lot. :-D
Received on Sat Sep 15 2007 - 22:35:25 CDT
