SQL Developer script not running all lines

can u try running them like @<your patch here>/EMSTATUS.sql;

What version of SQL Developer?  It is working for me in 4 EA2.

All scripts are in the same directory.

Worksheet contains

@multiscript

multiscript.sql contains

@@archlograte.sql

@@blockers2.sql

Putting the cursor on @multiscript and hitting either f5 or f9 will run both contained scripts.

I've tried with an exit in the first script and without. Works either way.

Try experimenting with simpler scripts to eliminate

If you are planning to turn this into a production system you should probably use sqlplus rather than sqldeveloper.  SQLDeveloper's sqlplus compatibility isn't perfect yet, so try testing with sqlplus as well.

I'm not seeing this in either 3.2.20.09, or 4.0 EA2. 

I wonder if it is something which was fixed between 3.1 and 3.2.    Can you upgrade?

Could there be something in the individual scripts causing an abort?

Hi,

Note you can put a path in: Tools->Preferences->Database->Worksheet->'Select default path to look for scripts'

I tried the following:

c:\tmp\calltwoscripts.sql

set echo on

@@zone.sql

@@ztwo.sql

select 'finished' from dual;

c:\tmp\zone.sql:

select 'one' from dual;

c:\tmp\ztwo.sql:

select 'two' from sql;

in a worksheet run:

@c:/tmp/calltwoscripts.sql

Output:

> @@zone.sql

> select 'one' from dual

'ONE'

-----

one  

> @@ztwo.sql

> select 'two' from dual

'TWO'

-----

two  

> select 'finished' from dual

'FINISHED'

----------

finished  

Things that could go wrong:

Your scripts could end with 'exit'.

The paths could get mixed up: try @ (not @@) and full paths.

You could have hit a code issue which the worksheet does not recover from - in which case you should get output on the command line and or Logging Page in view messages.

Turloch

-SQLDeveloper Team

http://www.thatjeffsmith.com/archive/2012/06/how-to-collect-debug-info-for-oracle-sql-developer/

http://totierne.blogspot.co.uk/2013/07/user-check-on-sqldeveloper-worksheet.html