Python connect oracle database

Question

conn = cx_Oracle.connect('xxx',encoding='GBK')
cursor=conn.cursor()
r= cursor.execute("select * from TB_OBJECT_1063 ")
r.fetchone()

I run r.fetchone() for several times and it suddenly give the error,I want the cursor to jump this location and continue to next one

UnicodeDecodeError Traceback (most recent call last) in () ----> 1 r.fetchone().next()

UnicodeDecodeError: 'gbk' codec can't decode byte 0xaa in position 203: illegal multibyte sequence

Your data in at least one row is not in the encoding you are expecting. — Klaus D.
– Klaus D., Commented Sep 13, 2017 at 9:27

Hennich · Accepted Answer · 2017-09-13 09:39:55Z

0

This sounds like you need try-catch.

try:
  r.fetchone()
except UnicodeDecodeError:
  pass

and then you may replace pass by whatever you need.

answered Sep 13, 2017 at 9:39

Hennich

7204 silver badges22 bronze badges

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

1 Answer 1