不用子程序如何解决Oracle存储过程,函数或触发器行太多的问题?

一般建议先写pl/sql块，在调试成功后在写入存储过程中。最大长度不太清楚，不过我写过三百来行的，没有什么问题。估计写个一两千行没什么问题，再长写在一个存储过程里，就不太好了。

存储过程几百行是非常常见的，我经常写长达上千行的package，也没碰到过你这样的错误。这个错误比较讨厌，下面是详细说明：

PLS-00707 unsupported construct or internal error [string]
Cause: At run time, this is an internal error. At compile time, it indicates one of the following problems:
- A call was made to a remote subprogram that has a parameter type or default expression not supported at the calling site.
- An incomplete upgrade or downgrade was done to a database that has
stored procedures. Perhaps incorrect versions of system packages such as STANDARD.SQL were installed.
- A compiler bug was encountered. In such cases, legal PL/SQL syntax will fail to compile.
Action: Either report the internal error to Oracle Customer Support or, depending on the problem, take one of the following actions:
- Revise the logic of the application to use parameter types and default expressions that are supported at both the local and remote sites.
- Complete the upgrade or downgrade properly, making sure to install
correct versions of all system packages.
- Report the legal-syntax error to Oracle Customer Support. If there are line and column numbers displayed with the error message, they might help you find a workaround. For example, try recoding the offending line to avoid the bug.

你把发生错误的行前后帖出来看看是什么内容