PLS-00123 program too largeCause: PL/SQL was designed primarily for robust transaction processing. One consequence of the special-purpose design is that the PL/SQL compiler imposes a limit on block size. The limit depends on the mix of statements in the PL/SQL block. Blocks that exceed the limit cause this error.Action: The best solution is to modularize the program by defining subprograms, which can be stored in an Oracle database. Another solution is to break the program into two sub-blocks. Have the first block INSERT any data the second block needs into a temporary database table. Then, have the second block SELECT the data from the table.
解决方案 »
- 如何查找oracle环境变量
- TNS: 协议适配器错误
- 如何改写查询中的or条件
- create index..(bsm asc) 与create index ..(bsm)的区别
- Error while trying to retrieve text for error
- ASP+ORACLE查询问题
- 在sql2000中的存储过程,清高人们帮忙给写成在oracle中可以执行的存储过程
- 关于数据库的一个问题,解答立即给分
- 我的数据库字符集是AL16UTF16?怎么办?
- 这样的外联接oracle8i中怎样实现呢?
- 删除数据库之前忘了删除例程了,怎么再删除这些例程?
- Oracle8.17 For Solaris
alter system set db_block_size=12000;
alter system set db_block_size=12000;-->严重疑问, db_block_size可以改吗? 我的印象是不能改的
8i是不能改的,9i我是不知道了