I did find a reference for oracle 8.0 that supports returning clause...
I've moved this to a ticket request in trac:
http://www.sqlalchemy.org/trac/ticket/1878
On 8/14/2010 11:14 AM, Kent Bower wrote:
Not a myth, I'm using them (via sqla). Simple views (just one table)
oracle figures out
I'm connecting to a legacy database, some tables that I need to map in
sqla have no primary key. I've created views for such tables that map
the ROWID as the primary key. SQLAlchemy does a RETURNING clause when
I am connected to a more recent Oracle database, but not when
connected to 8i.
I've
On Aug 14, 2010, at 9:34 AM, Kent wrote:
I'm connecting to a legacy database, some tables that I need to map in
sqla have no primary key. I've created views for such tables that map
the ROWID as the primary key. SQLAlchemy does a RETURNING clause when
I am connected to a more recent Oracle
Not a myth, I'm using them (via sqla). Simple views (just one table)
oracle figures out writes to all alone. For more complex views (joins
of tables), you can use an INSTEAD OF trigger to write to the view
(just pl/sql trigger where you tell Oracle what you want to happen when
someone