Change <class 'cx_Oracle.Cursor'> to list or dict in python

Question

I am working on a code to fetch data from a server and then plot two column of data in python. I am using cx_Oracle library and I could fetch data.

But as I checked type of fetched data is class 'cx_Oracle.Cursor'.

How can I change data type to list or dictionary :

import cx_Oracle

conn_str = u'user/pass@IP1:1521/STAT4P'
conn = cx_Oracle.connect(conn_str)
c = conn.cursor()
sql='''select ne,sdate,slot_no,subrack_no,ID_73393960 as HIII,ID_73410486 from Huawei_wcdma.UDSP60 where ne=:name'''

# c.execute(u'select ne,sdate,slot_no,subrack_no,ID_73393960,ID_73410486 from Huawei_wcdma.UDSP60')
c.execute(sql,name="AQRNCH01")
print(type(c))

I want to plot sdate vs. ID_73393960 , but how ?

Paul Becotte · Accepted Answer · 2018-03-27 05:05:44Z

2

In your code "c" is the cursor... it is NOT your data. you need to pull the data out using a fetch command. This is an example from the cx_oracle tutorial using fetchone()-

https://github.com/oracle/python-cx_Oracle/tree/master/samples/tutorial (Try the tutorial to learn the rest of the methods on the cursor object)

import cx_Oracle

con = cx_Oracle.connect("pythonhol", "welcome", "localhost/orclpdb")
cur = con.cursor()

cur.execute("select * from dept order by deptno")
row = cur.fetchone()
print(row)

row = cur.fetchone()
print(row)

edited Mar 27, 2018 at 5:05

answered Mar 27, 2018 at 4:45

Paul Becotte

9,9973 gold badges36 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sadegh Over a year ago

Thanks Paul for your reply, but my data is a matrix of 1000*10,000 data stats and using this, I will have only one rpw of data , am I right ? how to fetch all data in a column ?

abarnert Over a year ago

Does a Cursor work as an iterator? It's supposed to be a PEP 249/DB-API2 implementation. Not that next(cur) is any clearer than cur.fetchone(), but, e.g., a generator expression over cur is a lot clearer than a generator expression over iter(cur.fetchone, None).

Paul Becotte Over a year ago

I was saying that while my answer is the specific error you asked about, you are going to need to read the docs to answer the next three problems you are going to have.

Collectives™ on Stack Overflow

Change <class 'cx_Oracle.Cursor'> to list or dict in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related