can you please include the SQLAlchemy version and Oracle version in use? as well as an example Table model. These issues should be resolved for Oracle, the label names are truncated automatically.
On Mon, Mar 22, 2021, at 8:28 AM, Aurèle Durand wrote: > Hello, > > SqlAchemy automatically specify the table name in front of columns and thus > my query parameters are too long and I get the "(cx_Oracle.DatabaseError) > ORA-00972" error on Oracle. For example if my table name is > "TABLE_NAME_TOO_LONG" and my columns are "id" and "name" a request will look > like this: > > SELECT "TABLE_NAME_TOO_LONG".id, "TABLE_NAME_TOO_LONG".name FROM > "TABLE_NAME_TOO_LONG" where ... > > I could use alias for select request in order to bypass this issue if I > understand well > (https://www.tutorialspoint.com/sqlalchemy/sqlalchemy_core_using_aliases.htm). > > However for an insert I cannot find any solution. > > Is there a way to set an alias to a table name for an insert ? or remove the > table name ? > > Best regards ;) > > > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/03d4cb6c-ce89-47ee-bf5d-58d0c162667fn%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/03d4cb6c-ce89-47ee-bf5d-58d0c162667fn%40googlegroups.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/c0da71de-d3e6-4fa9-98ff-9ad5f7dc0b43%40www.fastmail.com.
