SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in [11.1.125 Pro] - Oracle dbms_output.put_line      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic [11.1.125 Pro] - Oracle dbms_output.put_line Author Message gemisigo Joined: 11 Mar 2010 Posts: 2165 [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: 7948 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: 2165 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: 7948 Sorry for the inconvenience. This defect will be fixed in the next maintenance release 11.2 Mon Feb 17, 2020 9:39 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.