You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
In Oracle database ,I create one table like this:
then I want to read metadata and row data like this:
but thow NotSupportedError when run at function oracle_cursor.execute(sql), and exeption is:
so, What can I do?
The text was updated successfully, but these errors were encountered: