| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2167
|
|
 [11.1.125 Pro] - Oracle dbms_output.put_line |
 |
It seems that the output from the dbms_output.put_line function gets truncated after the first 256 characters.
|
|
| Wed Feb 12, 2020 10:44 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7951
|
|
| |
|
I inquired and apparently there is some internal buffering capped at 256 characters per line. And I asked if that can be increased to match max size for VARCHAR2, not for CHAR as it stands now.
|
|
| Thu Feb 13, 2020 9:13 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2167
|
|
| |
|
Thank you very much!
EDIT:
It seems the same applies to the fields of the result set too. When selecting varchar2 columns with more than 256 characters in them, their contents get truncated.
|
|
| Fri Feb 14, 2020 6:25 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7951
|
|
| |
|
Sorry for the inconvenience. This defect will be fixed in the next maintenance release 11.2
|
|
| Mon Feb 17, 2020 9:39 am |
|
|
|
