[Dbix-class] Catalyst Application : DBIx::Class : Oracle 8 : JOIN problem

[Peter Rabbitson]

Rohan M wrote:
> Dear All,
> 
>  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.
> It doesn't understand 'JOIN' keyword in the SQL generated by DBIx::Class.
> 
> for example - >
> 
> my $Info = $c->model('App::Log')->search({
> id => $someid,
> },{
> join => 'foreignkey_id',
> });
> 
> I did checked 
> "http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage/DBI/Oracle/WhereJoins.pm" 
>  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.
> 
> Also I checked for join_type parameter which allows you to go for 
> 'outer' or 'inner' join but it didn't work.
> 
> Could some body tell me how can I use join for oracle 8i using 
> DBIx::Class model in the Catalyst application?
> 
> 

Sorry for the untimely reply - I am looking over old unanswered
messages on the ML. Was your problem eventually resolved, or is
it still present?