Retrieve oracle view containing clob to dataframe

[ibreeden]

File "C:/user/Personal/Scripts/oracledb1.py", line 12, in <module> dsn = cx_Oracle.makedsn(host='xx.xx.xx.xx',port=xxxx,sid=None,service_name='test')

NameError: name 'xxxx' is not defined

Obviously you need to fill in the real values instead of the 'xx*'. For host you have to fill in the name or ip address of the database server. The port is usually 1521 unless configured differently. The service_name is the name of the database.