PL/SQL functions do not work with big VARCHARs
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8375 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Problem Description
PL/SQL functions can't handle big string data and fail with the exception too big string parameter
Prerequisites for this behavior:
- a PL/SQL function is called with a CHAR or VARCHAR parameter
- the string data in this column is in average bigger than 8000 characters
- the function is called on more than 1000 rows
Workaround
Implement the function as a SCALAR RETURNS UDF.
