I'm trying to use sqlalchemy 0.1.3 with Oracle 9i and cx_Oracle, but can't get far.
I wrote Table and Mapper objects for an existing schema, It has fairly verbose table and column identifiers, like SHAMPOO_CLASS.SHAMPOO_OR_CONDITIONER_TYPE let's say. Running a simple select() on the ShampooClassMapper generates this SQL: SELECT shampoo_class.shampoo_or_conditioner_type AS shampoo_class_shampoo_or_conditioner_type FROM shampoo_class Which leads to this Oracle error: sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-00972: identifier is too long (The identifier after an AS keyword is limited to 30 characters on Oracle.) This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
