Think about Loose Coupling | |
PerlMonks |
Dbic and inflating Oracle DATE columns - solvedby Ea (Chaplain) |
on Jan 14, 2019 at 10:27 UTC ( [id://1228524]=perlquestion: print w/replies, xml ) | Need Help?? |
Ea has asked for the wisdom of the Perl Monks concerning the following question:
Newbie trying to get DBIx::Class to work with Oracle DATE columns. Managed to get my error to go away, so I'm putting this out there for expert comment and for those newbies searching on the same problem.
I used dbicdump with components=["InflateColumn::DateTime"] on an Oracle schema which produced a Result class which has but after searching with dbic and getting a resultset calling $resultset->start_time would give me DBIx::Class::InflateColumn::DateTime::catch {...} (): Error while inflating '24-APR-18' for start_time on Timetable::Schema::Result::Ical: Invalid date format: 24-APR-18. There are lots of hints in the documentation, but nothing explicit on how to avoid this error. I found that the error went away when I added the on_connect_call option to the connect method.
Just thought I'd get it down while it was fresh in my mind and I'll update the post when I know more about what I've done. ta! EditThe more documentation I read, the more I think I did the Right Thing.
EaSometimes I can think of 6 impossible LDAP attributes before breakfast.Mojoconf was great!
Back to
Seekers of Perl Wisdom
|
|