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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i PL/SQL Cursors and Joins

Re: Oracle 9i PL/SQL Cursors and Joins

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 16 Jan 2003 18:50:44 +0300
Message-ID: <b06kcj$1c5$1@babylon.agtel.net>


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...

> 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.
>
Received on Thu Jan 16 2003 - 09:50:44 CST

Original text of this message

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