PLS-00123: program too large (string)

PLS-00123: program too large (string)
Cause: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00123：程序太大（字符串）,
.原因： PL / SQL主要用于强大的事务处理。专用设计的一个后果是PL / SQL编译器对块大小施加了限制。限制取决于PL / SQL块中语句的混合。超出限制的块会导致此错误。,
.操作：最好的解决方案是通过定义可以存储在Oracle数据库中的子程序来对程序进行模块化。另一个解决方案是将程序分解成两个子块。将第一个块插入第二个块所需的任何数据到一个临时数据库表中。然后，让第二个块从表中选择数据。,
.

aiaiDBA

13718043309

010-86462881

PLS-00123: program too large (string)

1 个回答

相似问题