PL/SQL 报错:A query with LOB's requires OCI8 mode, but OCI7 mode is used
来源:互联网 发布:好看的小说知乎 编辑:程序博客网 时间:2024/05/21 08:39
在用pl/sql对客户的数据进行查询时,pl/sql给我报了如下的错误 :
我使用的pl/sql的版本号为:9.0.0.1601.
解决办法:
1. 换个更高版本的pl/sql
2.更改pl/sql的配置
a) tools --> Preferences
b) 将 Oracle --> Connection 里面的 Force OCI7 mode on OCI8 不要勾选
c) 保存后重启pl/sql。
注:什么叫做OCI?
ORACLE调用接口(Oracle Call Interface简称OCI)提供了一组可对ORACLE数据库进行存取的接口子例程(函数),
通过在第三代程序设计语言(如C语言)中进行调用可达到存取ORACLE数据库的目的。
- PL/SQL 报错:A query with LOB's requires OCI8 mode, but OCI7 mode is used
- PL/SQL 报错:A query with LOB's requires OCI8 mode, but OCI7 mode is used
- 【plsql-dev】PL/SQL 报错: A query with LOB's requires OCI8 mode, but OCI7 mode is used
- A query with lob's requires oci8 mode but oci7 mode is used plsql developer
- a query with LOB's requires OCI8 mode, but OCI7 mode is used 解决方法
- Redis连接报错:DENIED Redis is running in protected mode because protected mode is enabled
- invalid mode 报错
- hadoop 报 Name node is in safe mode 错
- 报错: Name node is in safe mode.
- hadoop报错Name node is in safe mode
- 搭建elsticsearch集群 报错with the same id but is a different node instance解决办法
- ORA-12720: operation requires database is in EXCLUSIVE mode
- ORA-12719: operation requires database is in RESTRICTED mode
- 【TaoTao】Jedis junit测试 报错 Redis is running in protected mode because protected mode is enabled…
- Spring 整合 Redis报错 DENIED Redis is running in protected mode because protected mode is enabled, no b
- sql-mode
- ENTER-QUERY Mode
- 【tensorflow】Input to reshape is a tensor with xxx values, but the requested shape requires a multipl
- [数据结构]第二章--线性表(读书笔记3)
- SKW17 AR9271 USB无线网卡驱动移植
- wince6.0下应用程序自启动(总结)
- java取的3月第二个周日
- Linux下配置C++开发环境之ACE编译
- PL/SQL 报错:A query with LOB's requires OCI8 mode, but OCI7 mode is used
- memcpy
- 鼠标右键MSYS或者Cygwin打开当前目录
- 命令行设置及查看java classpath设置
- sp Servlet基础入门学习篇 一、Servlet和JSP概述
- Joomla1.5学习笔记
- <script>位置
- linux常用性能监控命令
- 用标签搜索的方式搜索百度电影