Hello I have Oracle Express Release 10.2.0.1.0, SQLAlchemy 0.4.5, Python 2.5.2 on Ubuntu x86 8.04.
When I go through the ORM tutorial at http://www.sqlalchemy.org/docs/04/ormtutorial.html it fails at the first query below the heading *Saving Objects* with an Oracle ORA-01400 error as follows: sqlalchemy.exceptions.DatabaseError: (DatabaseError) ORA-01400: cannot insert NULL into ("BRUCE"."USERS"."ID") 'INSERT INTO users (id, name, fullname, password) VALUES (:id, :name, :fullname, :password)' {'fullname': 'Ed Jones', 'password': 'edspassword', 'name': 'ed', 'id': None} My create_engine string was engine = sa.create_engine('oracle://bruce:[EMAIL PROTECTED]', echo=True) The superficial reason for the error is obvious. Is this an Oracle eccentricity? Is there a workaround? Regards Bruce --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---