On Dec 3, 2009, at 6:12 AM, Nicola Lacquaniti wrote:
> I tried the same thing, but I obtain an 'ORA-01843: not a valid month'
> message from the backend.
can you try 0.6 trunk please, and ensure you're on the latest version of
cx_oracle as well. Oracle test coverage is not at 100% in 0.5 but is in trunk.
You shouldnt need to affect any nls_date_format stuff. its possible we dont
have coverage for Oracle TIMESTAMP and there's issues we haven't covered yet.
> This is my model:
>
> class BaseObject(Base, Dictionaryable):
> __tablename__ = 'baseobj'
>
> id = Column(Integer, Sequence((__tablename__+'id_seq')[-30:]),
> autoincrement=True, primary_key=True)
> realtype = Column(Unicode(30), nullable=False, index=True)
>
> codice = Column(Integer, nullable=True)
> nome = Column(Unicode(255), nullable=False)
> nonattivo = Column(TIMESTAMP , nullable=True)
> notanonattivo = Column(Unicode(255), nullable=True)
>
> After a commit I have:
> DatabaseError: (DatabaseError) ORA-01843: not a valid month
> 'UPDATE baseapparati SET nonattivo=:nonattivo,
> notanonattivo=:notanonattivo WHERE baseapparati.id
> = :baseapparati_id' {'baseapparati_id': 1, 'notanonattivo': '',
> 'nonattivo': '2009-12-03 11:41:07.457000'}
>
> I assigned to the object of type BaseObject a value
> datetime.datetime.now()
>
> Perhaps I can give the connection/session whatever a command like
>
> alter session set nls_date_format='DD/MM/YYYY';
>
> but I think I've done wrong something instead. So two questions:
>
> 1) where I was wrong? (better answare)
> 2) as an alternative, where can I give the alter session... command to
> get it activated in all sessions?
>
> thanks for the help!
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
