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