Re: ODBC vs. SQL*Net ???

From: Hans Guijt <hguijt_at_inter.nl.net>
Date: 1997/03/19
Message-ID: <679.7017T1213T1483@inter.nl.net>#1/1

Chris Greaves <cgreaves_at_expert.cc.purdue.edu> wrote:
> I am working on an app recently moved from one Oracle server to another.
> We are now using an ODBC connect, previously SQLNet Oracle 7v7.x, and
> two data windows with left outer joins no longer function. Is it possible
> that ODBC is causing the problem?

Something else you could check out: Oracle v7.2 on Novell machines has a bug in the optimizer which causes outer joins to fail. Turn off the optimizer with

dbms_utility.analyze_schema ('schema_name', 'DELETE');

and see if the problem goes away. If it does, you can either continue to work without optimization or go to Oracle v7.3 which fixes the bug.

H. Guijt Received on Wed Mar 19 1997 - 00:00:00 CST