[Dbix-class] date_time field for oracle

Jorge Gonzalez jorge.gonzalez at daikon.es
Thu Oct 27 06:46:34 GMT 2011

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 

I didn't know about this option about a year ago, and I had to do 
manually what this module does automatically. Grrr... :-)


El 26/10/11 13:13, Will Crawford escribió:
> On 26 October 2011 12:00, Roger Day<c.roger.day at gmail.com>  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/dbix-class@lists.scsys.co.uk

More information about the DBIx-Class mailing list