<div dir="ltr">To answer my own question here, I was getting weird SQL generated when the table name had the link in it; "linked_table\@linked_db" was corrupted into "lnkdtbl@lnkddb_M38DWUJS" (or something similar). I tried removing the "@linked_db" part from the DBIx::Class table name, and miraculously, it worked! It seems that although DBIx::Class::Schema::Loader doesn't process linked tables, DBIx::Class is able to use them transparently. Great!<div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 19 June 2015 at 17:29, Amelia Ireland <span dir="ltr"><<a href="mailto:aireland@lbl.gov" target="_blank">aireland@lbl.gov</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div><br></div><div>I generated the schema for both databases using DBIC::Schema::Loader separately as DBIC::Schema::Loader doesn't follow links.</div><div><br></div><div>I'm now trying to translate a nested select query into a DBIx::Class data structure and wrestle with the linked DB issue.</div><div><br></div><div>SELECT name, id </div><div>FROM local_table</div><div>WHERE alt_table_id</div><div>IN (</div><div> SELECT link_id</div><div> FROM linked_table\@linked_db</div><div>)<br></div><div><br></div><div>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? </div><div><br></div><div>Any help would be gratefully received.</div><div><br></div><div>Thank you!</div></div>
</blockquote></div><br></div>