Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i PL/SQL Cursors and Joins
Well well well... Another trouble in ANSI JOIN syntax support code... :)
Having seen a lot of different issues with it lately, I am still reluctant to
use it in my code... Hopefully v10 will do better with them.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Ben Stafford" <bstafford_at_sqlinsight.com> wrote in message news:SmoV9.155$05.31375546_at_newssvr30.news.prodigy.com...Received on Thu Jan 16 2003 - 09:50:44 CST
> I was able to duplicate the error in my own query, and truly the only
> problem is the use of "LEFT JOIN". If you replace the from and where clauses
> of the first cursor with the following text you should have no problems and
> the same expected results. I'm still investigating to find out why 'left
> join' is causing this.
>