大多数应用程序基本上不使用长数据类型.我在想要搜索软件包内容的地方做了类似的事情.解决方案是使用流水线函数将LONG转换为CLOB. Adrian Billington的源代码可以在这里找到: https://github.com/oracle-developer/dla

Long datatypes are basically unusable by most applications. I made something similar where I wanted to search the contents of packages. The solution is to convert the LONG into CLOB using a pipelined function. Adrian Billington's source code can be found here: https://github.com/oracle-developer/dla

您最终得到一个可以查询的视图.即使在查看大型包装时，我也看不到任何性能下降，因此它应该对您有用.

You end up with a view that you can query. I did not see any performance hit even when looking at large packages so it should work for you.