SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.1.125 Pro] - Oracle dbms_output.put_line

 
Reply to topic    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: 1741

Post [11.1.125 Pro] - Oracle dbms_output.put_line Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
Sorry for the inconvenience. This defect will be fixed in the next maintenance release 11.2
Mon Feb 17, 2020 9:39 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.