Post 7.0.6.00.02 hot fix install, Data Type Length has changed to varchar (2147483646)
Article ID: KB0080758
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6.00.02 |
Description
A view uses the LISTAGG function against an Oracle Data Source. In 7.0.4 it's data type length is varchar(4000). In 7.0.6.2 the data type length changed to Varchar(2147483646). Why has this changed and are there other functions that could also be impacted?
Issue/Introduction
A view uses the LISTAGG function against an Oracle Data Source. In 7.0.4 it's data type length is varchar(4000). In 7.0.6.2 the data type length changed to Varchar(2147483646). Why has this changed and are there other functions that could also be impacted?
Resolution
For any past implementations, the columns need to be CAST as VARCHAR(4000).
This is an expected behavior after the code change in 7.0.6 version. LISTAGG was modified in the latest versions to support column sizes > 4000. It no longer has this limitation.
This is an expected behavior after the code change in 7.0.6 version. LISTAGG was modified in the latest versions to support column sizes > 4000. It no longer has this limitation.
Feedback
Yes
No
Powered by
