473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

cx_Oracle.NotSupportedError

cpiyush
31
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.
May 7 '07 #1
2 6609
cpiyush
31
Hi got the actual problem in the above code, this is not because of that constraint clause, actually its because of that TIMESTAMP datatype of oracle. cx_Oracle's object is not supporting this type(I dunno why...), but it supports timestamp() function.

Probably this type is not defined in the definition of cx_oracle module.

Now can you please tell me how to resolve this problem in python??...means I want to get all the field types of above mentioned table definition, which includes timestamp also as a type.

Let me explain my problem in a more simple way...
I have created a cx_oracle connection object called 'connOb'.

I have created a table with this definition:
connOb.cursor.execute("CREATE TABLE SAMPLE(TS TIMESTAMP(6))")

Now I want to execute this command: -
connOb.cursor.execute("select * from sample").

Then Its giving me error: -
cx_Oracle.NotSupportedError: Variable_TypeByOracleDataType: unhandled data type 187
So considering the above explained scenario can you plz tell me how can I do this??(Hope you have got the problem..)

Thanks & Regards,
cPiyush.
May 7 '07 #2
cpiyush
31
Hi...

Got the solution.

I was using cx_Oracle 4.1.2 interface, which doesn't support TIMESTAMP data type.
I replaced it with the latest version of cx_Oracle i.e. 4.3.1 & not its working.

Hope no one else will do the same mistake againg.

Regards,
cPiyush.
May 9 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: GrayGeek | last post by:
After cx_Oracle and the related Oracle tools for Python 2.2.3 + Boa-constructor on Win2000, I added "import cx_Oracle" to the top of a test script. It gives me an error about being unable to find...
8
by: Rodrigo Daunaravicius | last post by:
I can't get this configuration working: cx_Oracle 4.0.1 Oracle 8.0.6 Python 2.3.3 Win NT4.0 SP6fc My first shot at the problem was just running the installation thingie pre-built for...
1
by: Greg Lindstrom | last post by:
>Shouldn't this be '/u01/app/oracle/product/9.2.0' ? Based on the following values, that's what I'd expect. I changed the ORCALE_HOME environment variable to the above suggested value and got a...
1
by: jmdeschamps | last post by:
Hello Having cx_Oracle (an Oracle database connector for Python) used it here where I teach for the last couple of years, and finding it so easy to use (and install) I was taken aback when I got...
5
by: Daniel | last post by:
Hello from Brazil :-) I'm trying to bring cx_Oracle alive on my Python 2.4.1 @ HP-UX 11 (suckz) and Oracle 10.1.0 64bits without success I've already tryied the suggestions from Bernard Delmée...
8
by: Richard Schulman | last post by:
Sorry to be back at the goodly well so soon, but... ....when I execute the following -- variable mean_eng_txt being utf-16LE and its datatype nvarchar2(79) in Oracle: cursor.execute("""INSERT...
7
by: Carl K | last post by:
I am trying to use this: http://python.net/crew/atuining/cx_Oracle/html/cx_Oracle.html it is a real module, right? sudo easy_install cx_Oracle did not easy_install cx_Oracle. ...
1
by: Lukas Ziegler | last post by:
Hi, I want to get an access to an oracle database. For that I found the module cx_oracle (http://www.python.net/crew/atuining/cx_Oracle/) and I have installed the version 'Windows Installer...
3
by: Benjamin Hell | last post by:
Hi! I have a problem with the cx_Oracle module (Oracle database access): On a computer with cx_Oracle version 4.1 (Python 2.4.3, Oracle 10g) I can get query results consisting of strings...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.