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

Home -> Community -> Usenet -> c.d.o.misc -> ORACLE 7.3 using ODBC and Left Outer Joins...

ORACLE 7.3 using ODBC and Left Outer Joins...

From: Steve Meier <sdmeier_at_jcn1.com>
Date: Mon, 5 Apr 1999 15:22:42 -0500
Message-ID: <37091c7d.0@news.primary.net>


In a document from Oracle "Using The Oracle ODBC Drivers with Thrid Party Products", the talk about Joins and the Oracle ODBC Driver. They state that they support the JOIN operation in version 2.x of the driver. We are running v2.05.0301. They go on to say that the only supported syntax is the "ODBC JOIN Escape syntax", not Oracle syntax. Then give an example:

select dept.deptno, sum(sal) from {oj dept left outer join emp on dept.deptno = emp.delpno} group by dept.deptno

Here's the statement I'm using:

SELECT S.SECTIONNUM, S.UPSECTION, S.PIECE, S.SECT_TYPE, S.CONDUCTOR AS SectionConductor, S.PHASE, S.MAPNAME, C.CONDUCTOR AS ConductorConductor FROM {oj SECTIONS S LEFT OUTER JOIN CONDUCTO C ON S.CONDUCTOR = C.CONDUCTOR} WHERE S.SECTIONNUM <> '-1' OR S.SECTIONNUM IS Null ORDER BY S.SECTIONNUM, S.PIECE If I run it with the oj in the statement after the FROM {, I get the following error:

SQLSTATE: S1000
Native Error Code: 1719
Driver Message:[Oracle]ODBC Oracle Driver][Oracle OCI][ORA-01719: outer join operator (+) not allows in operand of OR or IN.

If I don't include the oj when I run it I get a syntax error.

Anyone got any ideas on what the syntax for this is supposed to look like?

Any help would be greatly appreciated!

    -Steve Received on Mon Apr 05 1999 - 15:22:42 CDT

Original text of this message

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