Dear All,<div><br></div><div> I'm using Oracle 8i as a back-end database server for my Catalyst application. When I try to use join parameter using DBIx::Class model, it gives me syntax error.</div><div>It doesn't understand 'JOIN' keyword in the SQL generated by DBIx::Class.</div>
<div><br></div><div>for example - ></div><div><br></div><div><div>my $Info = $c->model('App::Log')->search({</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>id => $someid,</div>
<div><span class="Apple-tab-span" style="white-space: pre; "> </span>},{</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>join => 'foreignkey_id',</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>});</div>
</div><div><br></div><div>I did checked "<a href="http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage/DBI/Oracle/WhereJoins.pm">http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage/DBI/Oracle/WhereJoins.pm</a>" where it is mentioned that DBIx::Class automatically detects the version and calls the above class to generate the JOIN in oracle 8i fashion but somehow its not working.</div>
<div><br></div><div>Also I checked for join_type parameter which allows you to go for 'outer' or 'inner' join but it didn't work.</div><div><br></div><div>Could some body tell me how can I use join for oracle 8i using DBIx::Class model in the Catalyst application?</div>
<div><br></div><div><br></div><div>Thanks and regards,</div><div>Rohan</div><div><br></div><div><br></div><div><br></div><div><div><br></div></div><meta http-equiv="content-type" content="text/html; charset=utf-8">