Does anybody know how to keep SQL Developer from automatically editing PL/SQL code and adding line breaks after 'CREATE OR REPLACE' statements? It keeps taking:
CREATE OR REPLACE PACKAGE DEVELOPER AUTHID DEFINER And turns it into:
create or replace
package developer AUTHID DEFINER
This unwanted linebreak causes our autodeployment processes to break.
University of Notre Dame
Edited by: user9133268 on Feb 21, 2012 8:00 AM
I believe nothing for this issue has progressed since it was asked here: 2.1 RC Extra Line Breaks
As there may be approval for some planned improvements to the SQL Formatter feature in 3.2, I logged an enhancement request for you: Bug 13744858 - FORUM: UNWANTED LINE BREAK AFTER CREATE OR REPLACE SYNTAX
SQL Developer Team
Edited by: Gary Graham on Feb 21, 2012 4:19 PM
But if you have control over your auto-deployment process code, it might be quicker to enhance that to deal with CREATE OR REPLACE on the same or the preceding line. Also, note that if you edit the package DDL to put the CREATE OR REPLACE on the same line with the package name in the code editor, then immediately use Export or Save Package Spec and Body to save it to disk, then PACKAGE <name> will appear on the same line as the CREATE OR REPLACE syntax.
We were so happy with the line breaks finally removed in version 3.2.10!
But suddenly in 3.2.20 they re-appear! (And 3.2.10 seems not downloadable anymore)
What's going on? Why are the line breaks adde again?
The 'fix' was removed as it broke the debugger.
I deemed a broken debugger as a larger problem than an unwanted line break.
Obviously we want you to have the best of both worlds, so this remains on our to-do list.