ORU-10027:buffer overflow,limit of 2000 bytes问题的解决
来源:互联网 发布:云承家居设计软件 编辑:程序博客网 时间:2024/06/09 17:21
方法1:set serveroutput on size 10000000 //设置大点,默认为2000 bytes
方法2:exec dbms_output.enable(999999999999999999999); //设置大点,默认为2000 bytes
出现这个错误的原因是因为dbms_output缓冲区的溢出。具体如下:
The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers.
The PUT and PUT_LINE procedures in this package enable you to place information in a buffer that can be read by another trigger, procedure, or package. In a separate PL/SQL procedure or anonymous block, you can display the buffered information by calling the GET_LINE procedure.
这个包提供了这个缓冲区,但是这个缓冲区大小是有限制的,像上面的两个方法那样设置大小,问题就可以解决。
原文:http://jyblive.i.sohu.com/blog/view/83486382.htm
- 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问题的解决
- ORU-10027:buffer overflow,limit of 2000 bytes问题的解决
- ORU-10027:buffer overflow,limit of 10000 bytes问题的解决
- oracleORA-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 2000 bytes
- ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes的解决办法
- ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
- ORU-10027: buffer overflow, limit of 10000 bytes
- 【Oracle】存储过程打印问题—— ORA-20000:ORU-10027:buffer overflow,limit of 2000 bytes.
- dbms_output.put_line 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 10000 bytes 解决方法
- 中文字符编码标准+Unicode+Code Page
- ucos中的三种临界区管理机制(OS_CRITICAL_METHOD的解释)
- TP-link设置
- 【再次求助】亲和数,在自己机子上能运行,在OJ平台上不能通过
- 解决Gallery滑动中不触发setOnItemSelectedListener事件
- ORU-10027:buffer overflow,limit of 2000 bytes问题的解决
- cpu cycle 。。和 cycle有啥区别?
- POJ-2752-Seek the Name, Seek the Fame
- 解释概念:主存、辅存、Cache、RAM、SRAM、DRAM、ROM、PROM、EPROM、EEPROM、CDROM、Flash Memory
- DataGridView 绑定列顺序
- ASP.NET中实现URL重写
- 文件恢复学习笔记 获取文件格式 fat32
- AsyncTask的使用
- 网页头部实例(1)