Does DBD::Oracle support left outer join

2010-05-21 Thread White, Richard L
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.

Re: Does DBD::Oracle support left outer join

2010-05-21 Thread Martin Evans
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,

Re: Does DBD::Oracle support left outer join

2010-05-21 Thread Bruce Johnson
On May 21, 2010, at 9:25 AM, 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

RE: Does DBD::Oracle support left outer join

2010-05-21 Thread White, Richard L
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

Does DBD::Oracle handle failover for RAC?

2010-05-21 Thread David McMath
Dear List, I posted this questions to perl.dbi.users but I understand that the mailing list is a better place to get information. I am experiencing a problem in which, when one node of my 11g RAC fails, all the connections to that node get hung for a while. Some applications support

Does DBD::Oracle handle failover for RAC?

2010-05-21 Thread mcdave
Dear List, I am experiencing a problem in which, when one node of my 11g RAC fails, all the connections to that node get hung for a while. Some applications support transparent failover, but Googl'ing around suggests that DBD::Oracle doesn't. For example,

RE: Does DBD::Oracle handle failover for RAC?

2010-05-21 Thread John Scoles
Long answer No with a But! Short answer Yes with a Maybe! You are actully the first one to ask about it since I took over maintaining DBD::Oracle 5 years ago. Here is my answer 1) Yes the article is old and well out of date (and very one sided as TD often is no wonder he is going