SQL Plus VS Pl/SQL Developer

[dgs!]

I develop all my code using PL/SQL Developer. Scripts I write always get tested before I hand them off to the DBA staff for execution in TEST/PROD.
Sometimes my scripts fail when the DBA staff executes them using SQL*Plus. PL/SQL Developer is very forgiving, but SQL*Plus is not.
Example:
Creating a table storage clause:
(
partition p9999 values (DEFAULT)
tablespace tablespace_name

 

[Marco Kalter]

There is no option for this, but you can add a "set sqlblanklines on" command to your scripts to instruct SQL*Plus to accept blank lines as part of a statement.

 

[dgs!]

Does PL/SQL Developer SET BLANKLINES OFF? It ignores blank lines.
If I'm going to take the time to add his option to my scripts, I may as well look a little harder to make sure they're removed.

 

[Marco Kalter]

The sqlblanklines feature is a SQL*Plus feature. It does not directly apply to SQL or PL/SQL processing. Therefore the SQL Window, Test Window and Program Window all accept blank lines.

The Command Window is compatible with SQL*Plus, and its default sqlblanklines setting is the same (off).

 

[William Robertson]

I always set up a "Run with SQL*Plus" tool and add it to the menu bar.