Perl DBI and INTERVAL values
I was having trouble using DBI to bind an interval value. Wonder if anyone has a better solution than this:
http://openbedrock.blogspot.com/2017/06/binding-parameters-for-oracle-interval.html
i could not find any information about binding an Oracle INTERVAL LITERAL. Maybe I just missed it in the docs?
I blog about Perl and Bedrock.
I toyed with this once years ago when I was the maintainer of DBD::Oracle
If memory serves me corretly I had problems getting a C data structure that worked and trying to get it to work with OCI8 and perl without breaking too much of the DBI spec.