linesize behaves differently in plsqldev than in sqlplus

[mato]

hello,

while output of "select text from user_source" stretches in sqlplus according to "linesize" parameter, it does not in pl/sql developer.
it's pretty annoying and renders many of my scripts less useful or difficult to work with.
why is it so?
can it be fixed to mimick sqlplus behaviour pls ??

cheers,

martin

 

[Marco Kalter]

There is no linesize limit in PL/SQL Developer's Command Window, so it's not really supported. I have added this to the list of enhancement requests though.

 

[CTzen]

Martin,

you can add column text format a200 to the Login.sql script, located in PL/SQL Developer directory. It works for me, see below

SQL> select text from user_source where text like '%calculateDisputeAmount%';

TEXT
--------------------------------------------------------------------------------
    FUNCTION calculateDisputeAmount(p_DISPUTE_TYPE_ID VARCHAR2, p_DISPUTE_STATUS
    FUNCTION calculateDisputeAmount(p_DISPUTE_TYPE_ID VARCHAR2, p_DISPUTE_STATUS
    END calculateDisputeAmount;

Executed in 0.125 seconds

SQL> column text format a200
SQL> select text from user_source where text like '%calculateDisputeAmount%';

TEXT
-----------------------------------------------------------------------------------------------------------
    FUNCTION calculateDisputeAmount(p_DISPUTE_TYPE_ID VARCHAR2, p_DISPUTE_STATUS_ID integer, p_MONTH VARCHAR2)
    FUNCTION calculateDisputeAmount(p_DISPUTE_TYPE_ID VARCHAR2, p_DISPUTE_STATUS_ID integer, p_MONTH VARCHAR2)
    END calculateDisputeAmount;

Executed in 0.14 seconds

 

[mato]

marco, thank you!

slava, thanks but the problem is that "column format" is column specific and i would have to modify my scripts, whereas with linesize it doesn't matter what column you select. /user_source.text was just an example./

 

[RMC]

My output is truncated and linesize does not work properly. wht are my options then?

 

[RMC]

Ahhh. I was concatenating it into one long field. THus I needed to add set colwidth.