[Dbix-class] Using DBIx::Class with linked databases in Oracle

[Amelia Ireland]

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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20150619/f32c4313/attachment.htm>