这是因为在过程中用到了dbms_output.put_line()在服务器端输出信息,而serveroutput 的size默认定义为10000bytes。
修改一下size应该就可以了
set serveroutput on 30000
ORA-20000 string
Cause:The stored procedure RAISE_APPLICATION_ERROR was called which causes this error to be generated.
Action:Correct the problem as described in the error message or contact the application administrator or database administrator for more information.
Cause:The stored procedure RAISE_APPLICATION_ERROR was called which causes this error to be generated.
Action:Correct the problem as described in the error message or contact the application administrator or database administrator for more information.