Hi,
I am using cx_Oracle Python-Oracle interface V4.2.
Its a great tool.
But I am facing one problem in using it.
I Have given a create table command: -
[HTML]CREATE TABLE JG_MESSAGE( ID NUMBER(12,0) NOT NULL ,SENDER VARCHAR2(32) NOT NULL ,CENTENTS VARCHAR2(4000) NOT NULL ,INTIME TIMESTAMP(6) NOT NULL ,HEADING VARCHAR2(255) DEFAULT NULL,THREADID NUMBER(12,0) DEFAULT 1,IP VARCHAR2(15) DEFAULT 'N/A', CONSTRAINT XP_JG_MESSAGE PRIMARY KEY(ID))[/HTML]
Table is created successfully.
Then I am giving "Select * from JG_MESSAGE", at this moment I am facing this error: -
[HTML]cx_Oracle.NotSupportedError: Variable_TypeByOracleDataType: unhandled data type 187[/HTML]
I think this is due to that constraint keyword in the create table query.
Can You please tell me how to get rid from this problem, as I have been given this DB schema, & I can not chnage its definition, & also I don't want to switch from cx_Oracle to any other tool.
Thanks & Regards
cPiyush.