Thanks all, It was a dumb user error, mine. Found it, corrected it have a good weekend.
Rich White Service Manager -- Illinois Compass University of Illinois at Urbana-Champaign -----Original Message----- From: Martin Evans [mailto:martin.ev...@easysoft.com] Sent: Friday, May 21, 2010 11:30 AM To: White, Richard L Cc: dbi-users Subject: Re: Does DBD::Oracle support left outer join White, Richard L wrote: > I'm getting an error when I try to use a "left outer join" in my Perl program. > I have not found anything about joins in the documentation of the DBD:Oracle > module. > I'm using DBD::Oracle v1.18 on Perl v5.8.5 to connect to our Oracle > 10.02.0400 dB. > > If it should work, I will continue to work on it. > > Rich White > Service Manager -- Illinois Compass > University of Illinois at Urbana-Champaign > > I don't think DBD::Oracle modifies your SQL or even cares about it other than if you've used bound parameters (where it /might/ parse the SQL to locate them). Oracle does support left outer joins. Show us a code snippet, the SQL and the error and we might be able to diagnose. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
