I have an Oracle schema that has a column name labeled as
'when' (without the quotes). Everything works fine in PL/SQL when
referencing this column -- not special handling needs to be done.
However, we created a sqlalchemy definition as follows:
monitor_mts_table = Table('monitor_mts', metadata,
Column('monitor_mts_id', Integer, Sequence('seq_monitor_mts'),
primary_key = True),
Column('when', OracleDateTime),
Column('status', Integer),
Column('created_date', OracleDateTime),
)
When we reference this we get a database error from oracle that the
column monitor_mts."when" does not exist. Notice the double quotes.
This is what is throwing off oracle since the column definition in the
table is not double quoted.
I have tried appending the clause quote=False to the Column definition
above but it does not affect what is being sent to the database --
still a doubled quoted column name.
Any ideas how to work around this without changing the underlying
table definition in Oracle?
Thanks,
Dan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
