[sqlalchemy] Re: oracle insert problem

2010-03-04 Thread celord
Thanks a lot Michael, now it works! this is my final script, maybe it could help others: engine = create_engine('oracle://user:passw...@host:1521/dbname', echo=True) metadata = MetaData() pushmail_table = Table('pushmail', metadata, Column('telefono', String, primary_key=True),

[sqlalchemy] Re: oracle insert problem

2010-03-02 Thread celord
Thanks Michael, I have changed all UPERCASE to lowercase http://www.pastebin.org/100149, the output has changed a bit but the table name is still quoted and the insert does not work sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00942: table or view does not exist 'INSERT INTO

Re: [sqlalchemy] Re: oracle insert problem

2010-03-02 Thread Michael Bayer
additionally don't shove a schema/owner name into your table's name field. Use the schema kw arg for that. On Mar 2, 2010, at 4:23 PM, celord wrote: Thanks Michael, I have changed all UPERCASE to lowercase http://www.pastebin.org/100149, the output has changed a bit but the table name is