3 Replies Latest reply on May 2, 2016 7:33 PM by thatJeffSmith-Oracle

    SQL Dev 4.1.3.20 Script Output Formatting defaults on Mac OS X

    Daniel J Van Der Meulen

      I'm having an issue with SQL Dev 4.1.3.20. In SQL Dev 3.1 I did not run into this issue but 3.1 no longer works after updating java so I downloaded the latest version. 3.1 worked right out the gate, 4.1 is a bear. 3.2 doesn't work either.

       

      The issue I'm running into is, unless I specify SET LINESIZE 32767; SET PAGESIZE 50000; when I first open a worksheet then the script output is off and a total mess. I can't get SQL Dev to default to these line and page size settings.

       

      For example, Before I run the set line size and page size commands:

       

      Screen Shot 2016-05-02 at 10.23.32 AM.png

       

      SHOW ALL

       

      appinfo is OFF and set to "SQL Developer"

      arraysize default

      autocommit OFF

      autoprint OFF

      autotrace OFF

      BTitle OFF

      colsep " "

      concat "." (hex 5c)

      copycommit 0

      define "&"

      echo OFF

      escape OFF

      FEEDBACK ON for 6 or more rows

      heading ON

      headsep "|" (hex 7c)

      linesize 80

      long 80

      longchunksize 80

      null null

      numformat ""

      numwidth 10

      pagesize 14

      PAUSE is OFF

      release 1102000400

      scan ON

      serveroutput OFF

      space " "

      spool OFF

      sqlcode 0

      sqlprompt "SQL>  "

      suffix "sql"

      termout ON

      timing OFF

      trimout OFF

      trimspool OFF

      TTitle OFF

      USER is "*******"

      verify ON

      wrap : lines will be wrapped

       

      After I run the line size and page size commands:

       

      Screen Shot 2016-05-02 at 10.25.05 AM.png

       

      My SHOW ALL after changing the line and page sizes

       

      appinfo is OFF and set to "SQL Developer"

      arraysize default

      autocommit OFF

      autoprint OFF

      autotrace OFF

      BTitle OFF

      colsep " "

      concat "." (hex 5c)

      copycommit 0

      define "&"

      echo OFF

      escape OFF

      FEEDBACK ON for 6 or more rows

      heading ON

      headsep "|" (hex 7c)

      linesize 32767

      long 80

      longchunksize 80

      null null

      numformat ""

      numwidth 10

      pagesize 50000

      PAUSE is OFF

      release 1102000400

      scan ON

      serveroutput OFF

      space " "

      spool OFF

      sqlcode 0

      sqlprompt "SQL>  "

      suffix "sql"

      termout ON

      timing OFF

      trimout OFF

      trimspool OFF

      TTitle OFF

      USER is "*******"

      verify ON

      wrap : lines will be wrapped

       

       

      I have looked everywhere in preferences and cannot find where to set a high level default for all DBs to default to the larger page and line size. Will I be forced to always run a formatting command when I want to run some SQL statements? Is there a setting I'm over looking? I've been through every one of the menu options and can't find a line size or page size anywhere.

       

      I tried turning off wrapping without the line size and page size changes and received !ROWSTRUNCATED! error messages and the information was truncated so that doesn't fix my issue plus I still have to enter a command before I run my script.

       

      Does anyone know where to default these settings at in the preferences?

       

      Thanks in advance for any assistance or advice you may provide. If need be I could always file an Oracle support ticket but thought I'd try the community first to see if anyone had the answer.