I'm querying an Oracle database with a number of linked tables and have not
yet been able to access the linked tables using DBIx::Class.
I generated the schema for both databases using DBIC::Schema::Loader
separately as DBIC::Schema::Loader doesn't follow links.
I'm now trying to translate a nested select query into a DBIx::Class data
structure and wrestle with the linked DB issue.
SELECT name, id
FROM local_table
WHERE alt_table_id
IN (
SELECT link_id
FROM linked_table\@linked_db
)
Is there any way to get DBICSL to acknowledge the linked tables when
creating the schema, and if not, how can I use DBIx::Class to perform the
nested select query?
Any help would be gratefully received.
Thank you!
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
