Set output text line size in DBMS Output tab of Test Window

[Michiel.A]

Hi,

Is there an option to make the DBMS_OUTPUT text in the DBMS Output tab in the Test Windows wider?
The text maximum width thats fits on one line is now very limited (under 80 chars).
Is there a setting somewhere to allow like 120 chars?

Thanks

 

[Marco Kalter]

I tested this up to 1000 characters and it works fine. You will need to scroll of course. Can you let me know your PL/SQL Developer version and your Oracle Server version?

 

[Michiel.A]

Hi Marco,

I had the same issue in several older versions as well, but curently i use PL/SQL developer version is 15.0.3.2059
Database is version 19c. (but also on earlier versions like 11c)

This is what my output looks like in the Test Windows DBMS Output tab:

cg$row tmi_countries%rowtype;

--  TMI_COUNTRIES row type variable
type cg$row_type is record (
     code                      cg$row.code%type
,    description               cg$row.description%type
,    iso_code                  cg$row.iso_co
de%type
,    iso_num                   cg$row.iso_num%type
,    customs_num               cg$row.customs_num%type
,    customs_desc              cg$row.customs_desc%type
,    eu_ind                    cg$row.eu_ind%type
,    efta_ind                  cg$r
ow.efta_ind%type
,    postal_code_ind           cg$row.postal_code_ind%type
,    home_no_ind               cg$row.home_no_ind%type
,    created_by                cg$row.created_by%type
,    creation_date             cg$row.creation_date%type
,    last_upd
ated_by           cg$row.last_updated_by%type
,    last_update_date          cg$row.last_update_date%type
,    id                        cg$row.id%type
,    postal_code_prefix        cg$row.postal_code_prefix%type
,    customs_code              cg$row.cus
toms_code%type
,    vat_number_mask           cg$row.vat_number_mask%type
,    vat_number_prefix         cg$row.vat_number_prefix%type
,    state_code_mandatory_yn   cg$row.state_code_mandatory_yn%type
,    access_code               cg$row.access_code%typ
e
,    sepa_ind                  cg$row.sepa_ind%type
,    user_select_yn            cg$row.user_select_yn%type
,    zip_code_mandatory_yn     cg$row.zip_code_mandatory_yn%type
,    iso2_code_datapool        cg$row.iso2_code_datapool%type
,    gcc_ind
               cg$row.gcc_ind%type
,    cry_id                    cg$row.cry_id%type
,    print_vat_prefix_yn       cg$row.print_vat_prefix_yn%type
,    ics2_yn                   cg$row.ics2_yn%type
,    the_rowid                 rowid
);

As you can see, several lines break, even when other longer lines get written correctly..

 

[Marco Kalter]

Could it that dbms_output is written including linefeeds?

As a test, can you run the following test script?

declare
  s varchar2(2000);
begin
  s := '*';
  for i in 1..1000 loop
    s := s || 'x';
  end loop;
  s := s || '*';
  dbms_output.put_line(s);
end;

Let me know if all 1000 characters are displayed on 1 line.

 

[Michiel.A]

Ok, that script works..
I will try to create a small test case to reproduce my issue..