I am not using the latest DBIx::Class but i can get that installed and try again. However we do alter the session and set the format of Dates to YYYY-MM-DD
---------------------------- Michael Blanco On Fri, Mar 5, 2010 at 11:10 AM, Ronald Straight <[email protected]>wrote: > On Fri, Mar 5, 2010 at 10:57 AM, Michael Blanco <[email protected]>wrote: > >> Hi, >> I received the error below running this update: >> $lineitem->update({ >> 'last_mod_date' => $now, >> 'creative_rcpt_date' => $now, >> }); >> >> Error with 1239848: DBIx::Class::Relationship:: >> CascadeActions::update(): DBI Exception: DBD::Oracle::st execute failed: >> ORA-01858: a non-numeric character was found where a numeric was expected ( >> > > You're passing the date in a format (the default "YYYY-MM-DD" from > DateTime) that Oracle does not expect. > > Are you using the latest DBIx::Class and including the > InflateColumn::DateTime component in your base result class? > > > _______________________________________________ > 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]
