ORA-20000: ORU-10027: 执行存储过程的错误
来源:互联网 发布:mp3定时编辑软件 编辑:程序博客网 时间:2024/06/04 20:34
Oracle数据库执行存储过程的错误解出现了错误,错误信息如下:
ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 18
经过一系列的分析以及查看网上的资料终于知道了问题的解决方法,出现的原因是因为我在存储过程中使用了dbms_output.put_line(); 由于过程中有循环,因此输出量比较大,致使缓存不够报错.
网上的解决方法是set serveroutput on size 100000 (相当于把缓存设置大一点),但是我执行时候报错 ORA-00922: missing or invalid option,之后还是修改了自己的语句,既然是输出过多导致,我就将数据语句放在循环外面,这样只要输出语句小于缓存就可以了.
- ORA-20000: ORU-10027: 执行存储过程的错误
- ORA-20000: ORU-10027: 执行存储过程的错误
- ORA-20000: ORU-10027: 执行存储过程的错误
- ORA-20000: ORU-10027
- 调试存储过程时提示ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
- 【Oracle】存储过程打印问题—— ORA-20000:ORU-10027:buffer overflow,limit of 2000 bytes.
- oracle跑存储时,报 ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes错误解决
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes问题的解决
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes问题的解决
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes问题的解决
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes的解决办法
- ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
- ORA-20000:ORU-10027:buffer overflow,limit of 2000 bytes.
- 存储过程结合游标的使用错误--------ORA-01403
- 怎样捕捉存储过程执行过程中出现的错误?
- Building the Build System – Part 1 – Abandoning the Build Panel
- uiview剖析
- 关于android手机应用创意
- 自制性能测试类
- TOMCAT原理以及处理HTTP请求的过程
- ORA-20000: ORU-10027: 执行存储过程的错误
- HTML文本框样式大全
- C语言的数据类型
- Building the Build System – Part 2 – Project Templates
- 配匹中文及全角符号
- 如何往IE工具条添加按钮
- JavaScript如何将json字符串转化为数组
- Mutex的简单封装
- java基础