SP2-00029
command buffer space exhausted
Cause
A large SQL or PL/SQL script is being executed from SQL*Plus.
Action
Reduce the size of the SQL statement or PL/SQL block by one of the following:
- Remove extra white space and comments.
- Re-code to use fewer commands and/or shorter variable names.
- Place sections of the block into stored (or packaged) procedures, and then call these procedures from the block.