Solved it - I missed the __PACKAGE__->load_components(qw/InflateColumn::DateTime/); call ...
cheers Roger On Wed, Oct 26, 2011 at 12:00 PM, 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 '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]
