Closed
Description
In Oracle database ,I create one table like this:
CREATE TABLE "TEST"."table_with_interval" (
"id" NUMBER,
"col1" INTERVAL DAY (2) TO SECOND (6),
"col2" INTERVAL YEAR (2) TO MONTH,
PRIMARY KEY ( "id" )
);
then I want to read metadata and row data like this:
oracle_cursor = self._connection.cursor()
sql = "SELECT * FROM \"TEST\".\"table_with_interval\" where rownum<1"
try:
oracle_cursor.execute(sql)
except Exception as e:
raise e
but thow NotSupportedError when run at function oracle_cursor.execute(sql), and exeption is:
NotSupportedError: Oracle type 2016 not supported.
so, What can I do?