Re: MDB2

On 12/5/05, Olivier Mansour <omansour@gmail.com> wrote: > > Le 4 déc. 05 à 08:24, Lukas Smith a écrit : > > > Justin Patrin wrote: > > > >> Someone else had a problem with quoteIdentifiers and oracle > >> lately.... > > It's me :-D > > >> I have no idea myself, though, as quotes (") on identifiers > >> works fine for me on the oracle servers I've tried it on. Also, you > >> can use identifiers on some fields and not others just fine. > > > > Yeah I saw this on the list. I was trying to debug this, but gave > > up after a while because the ext/oci8 is just too flaky if you do > > anything beyond the most basic queries. I have a commercial > > interest in the oracle driver, but that is covered with whatever > > the driver can do right now. So until someone sits down and debugs > > this or pays me to endure more of the amateur crap that they call > > the OCI API I am not going to bother. > > > > Actually I think it's more related to DB_nestedset and the way it use > to buid queries. > I notice that my version off Oracle (10g) need quotes on identifiers > in the SELECT clause but not in the FROM one and don't want quotes on > INTO TABLE (...). But, If your tests are OK I guess my configuration > of Oracle, or something else, is wrong. So I have to do more > investigations. > Ah....well, it's possible hat OCI8 or oracle has some problems with quoting in certain places. I didn't realize before that it was only in a specific part of your query. -- Justin Patrin