[Dbix-class] date_time field for oracle

[Roger Day]

it's not doing very much

  on_connect_call =3D> '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
<billcrawford1970 at gmail.com>wrote:

> 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 ch=
ar
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111026/e79=
47de6/attachment.htm