Python3读取Oracle Blob类型并存为pdf文件

Python3安装cx_Oracle

进入Python3安装目录，打开cmd窗口，输入命令：python -m pip install cx_Oracle --upgrade
或者在项目内输入同样的命令进行安装

D:\ProgramFiles\Python3102>python -m pip install cx_Oracle --upgrade
Collecting cx_Oracle
  Downloading cx_Oracle-8.3.0-cp310-cp310-win_amd64.whl (213 kB)
     |████████████████████████████████| 213 kB 262 kB/s
Installing collected packages: cx-Oracle
Successfully installed cx-Oracle-8.3.0

顺带升级pip版本：

D:\ProgramFiles\Python3102>python -m pip install --upgrade pip
Requirement already satisfied: pip in d:\programfiles\python3102\lib\site-packages (21.2.4)
Collecting pip
  Downloading pip-22.0.4-py3-none-any.whl (2.1 MB)
     |████████████████████████████████| 2.1 MB 192 kB/s
Installing collected packages: pip
  Attempting uninstall: pip
    Found existing installation: pip 21.2.4
    Uninstalling pip-21.2.4:
      Successfully uninstalled pip-21.2.4
  WARNING: The scripts pip.exe, pip3.10.exe and pip3.exe are installed in 'D:\ProgramFiles\Python3102\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
Successfully installed pip-22.0.4

主要Python编码

import cx_Oracle

def start():
    minID = 0
    maxID = 0
    outPath = "D:\\pdf\\"
    conn = cx_Oracle.connect(user="dbuser", password="dbpwd", dsn="127.0.0.1/orcl")
    cursor = conn.cursor()

    for row in cursor.execute(""" select * from tbl_attach """):
        #读取blob字段内容
        datas = row[5].read()
        #pdf名称字段
        name_origin = row[1]
        with open(outPath + name_origin, "wb") as f:
            f.write(datas)