it's not doing very much

  on_connect_call => 'datetime_setup',

adding the

__PACKAGE__->load_components(
qw/InflateColumn::DateTime/);

fixed my problems and I started getting datetime inserts, thanks.

Regards
Roger

On Wed, Oct 26, 2011 at 12:13 PM, Will Crawford
<[email protected]>wrote:

> 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]

Reply via email to