Skip to content

NotSupportedError: Oracle type 2016 not supported. #436

Closed
@tangyibo

Description

@tangyibo

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?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions