Hi,
In GT/SQL/Driver/ORACLE.pm in sub _prepare_select, can you add:
$query =~ s#FROM\s*(\w+)\s*LEFT OUTER JOIN\s*(\w+)\s*ON\s*(\w+)\s*=\s*(\w+)\s*WHERE\s*#
my ($t1, $t2, $c1, $c2) = ($1, $2, $3, $4);
if (index($c1, "$t1.") == 0) { "FROM $t1, $t2 WHERE $c1 = $c2(+)"; }
else { "FROM $t1, $t2 WHERE $c2 = $c1(+)" }
#;It's not tested, but looks like it should work. This will convert all left outer join queries to the (+) syntax oracle likes.
Cheers,
Alex
--
Gossamer Threads Inc.
In GT/SQL/Driver/ORACLE.pm in sub _prepare_select, can you add:
Code:
# No LEFT OUTER JOIN, reformat. $query =~ s#FROM\s*(\w+)\s*LEFT OUTER JOIN\s*(\w+)\s*ON\s*(\w+)\s*=\s*(\w+)\s*WHERE\s*#
my ($t1, $t2, $c1, $c2) = ($1, $2, $3, $4);
if (index($c1, "$t1.") == 0) { "FROM $t1, $t2 WHERE $c1 = $c2(+)"; }
else { "FROM $t1, $t2 WHERE $c2 = $c1(+)" }
#;
Cheers,
Alex
--
Gossamer Threads Inc.