下面是
原因:oracle从11g升级到18c
报错地方:SELECT DISTINCT bd_psndoc.* FROM bd_psndoc WHERE bd_psndoc.pk_psndoc = ‘’;
解决方案:1、去掉distinct后语句正常。
2、保留distinct,然后将字段类型是blob的字段用函数to_char转换。如:
SELECT distinct to_char(bd_psndoc.photo) FROM bd_psndoc WHERE bd_psndoc.pk_psndoc = ‘’;
原文出处链接。
https://blog.csdn.net/perfect_bug/article/details/103281644