SQLAlchemy + Database Link => ORA-04054

SQLAlchemy + Database Link => ORA-04054

I’ve got this SQLAclhemy table definition that describes a table I’ll be accessing over an Oracle database link:

I first created a database link such as this:

In SQLAlchemy, access a table column (in a query) via that link would look like tihs

I turns out that SQLAlchemy with Oracle database links isn’t a very good match, and easily results in errors such as this:

To work around this issue, I created a synonym like this:

Now, accessing the table via the database link is as easy as doing this:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: