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 'INSERT INTO Events ( application, corps, date_time, letter_code,
original_file, stream, suppressed) VALUES ( :p1, :p2, :<*>p3, :p4, :p5, :p6,
:p7 ) RETURNING event_id INTO :p8') [for Statement "INSERT INTO Events (
application, corps, date_time, letter_code, original_file, stream,
suppressed) VALUES ( ?, ?, ?, ?, ?, ?, ? ) RETURNING event_id INTO ?" with
ParamValues: :p1='package_mo', :p2='PKZZ', :p3='2011-10-26T11:50:14',
:p4='ABY_CLAPEN_1889', :p5='t/datain/ABY_CLAPEN_1889.dat', :p6='package_mo',
:p7='Y', :p8=undef] at
/usr/opt/perl5/lib64/site_perl/5.8.8/DBIx/Class/Schema.pm line 1078
I do this
$DBH = Dsti::CPP::Schema->connect($dsn,
$username,
$password,
{
AutoCommit => 1,
RaiseError => 1,
on_connect_call =>
'datetime_setup',
},
);
this
__PACKAGE__->add_columns(qw/event_id
stream
corps
letter_code
original_file
application
suppressed
/,
date_time => {data_type=>'datetime'},
);
and I set up the field in the create statement as DateTime type. Can anyone
please point me at what I did to do to get the correct behaviour?
Regards
Roger Day
_______________________________________________
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]
