The 'datetime_setup' is provided by the
DBIx::Class::Storage::DBI::Oracle driver, it sends the appropiate
commands to Oracle to set a compatible datetime format so that DateTime
objects are correctly built when retunring from the database (basically
issue an "ALTER SESSION SET NLS_DATE_FORMAT...." and other similar
commands).
I didn't know about this option about a year ago, and I had to do
manually what this module does automatically. Grrr... :-)
BR
J.
El 26/10/11 13:13, Will Crawford escribió:
On 26 October 2011 12:00, Roger Day<[email protected]> wrote:
Hi
I think I've done all the right things for inserting a date-time into a
Oracle date field, but I keep getting this:
DBI Exception: DBD::Oracle::st execute failed: ORA-01861: literal does not
match format string (DBD ERROR: error possibly near<*> indicator at char
120 in [...]
Usually this means Oracle is expecting a string in whatever your
locale is. Could you shed some light on what your "datetime_setup"
call is doing?
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
