I am using oci8 driver of luasql to access Oracle database. All the queries are working fine. But if I try to implement a date query as:
conn:execute "select sysdate from dual"
It throws as error:
invalid type 12 #
I read it somewhere that the oci8 driver doesnot support date datatype. And some steps were mentioned to add support but that they didnot work.
So does anybody know how to integrate support for date in oci8 driver?
Any help is appreciated.