Toad: Ver 18.104.22.168
The below script exists without processing all the records in the cursor, loops through ok if the tz_offset is not called. Works ok in Toad 10.5.1.3 and plsql.
Loop is exited after only 3 records printed in 22.214.171.124
cursor record is
select * from V$TIMEZONE_NAMES;
for r in record
c := tz_offset( r.tzname );
when OTHERS then
dbms_output.put_line( ‘Exception’ );
dbms_output.put_line( r.tzname || ’ ’ || c );
The method of polling for dbms output has changed in recent versions for efficiency and the new method is grabbing the null char that TZ_OFFSET() has at the end of each TZNAME. The null char is a string terminator in Delphi (language Toad is written in) so we’re losing most of the data. Until it’s resolved you can strip the null by c := replace(tz_offset(r.tz_name), chr(0));
Fixed for next beta if you’re in the beta program.