| Table of Contents |
|---|
Version
All versions
Explanation
Unable to create procedure or execute query.
Cause
This error occurs if either a long procedure or query that exceeds the maximum text buffer size of iSQL is created or executed.
Action
The maximum length that can be handled in iSQL is 655536, by default. This can be changed from an environmental variable called ISQL_BUFFER_SIZE.
Increase ISQL_BUFFER_SIZE to create a long procedure.
| Code Block | ||
|---|---|---|
| ||
$ export ISQL_BUFFER_SIZE=256000 |
Reference
N/A