3 Replies Latest reply on Apr 28, 2015 1:41 PM by Matthias E. Müller

Issue with SQL Developer 4.1 Early Adopter 2 - start sql-script by "@"

Matthias E. Müller Apr 2, 2015 2:15 PM

Hi,

today i realized, that starting a sql-script by writing @scriptname.sql in a sql worksheet and press F9 to start the script, does not work anymore.

With EA2 there is always an error message shown like "unkown command" with some strange characters "��" in the script logging window.

The sql-scripts are located in a filesystem folder the os environment variable SQLPATH points to.

In Version 4.0.x this worked perfect! Is this a planned "feature" or just a bug in EA2 fixed in later EA versions?

In addition, when i open such a sqlscript with the file open menu in sqldeveloper the content of the sqlscript is not shown in the script window. There are only some none printable characters "��" displayed in the sqlworksheet, and not the "select ..." a normal texteditor shows.

Thanks in advance

Matthias

1. Re: Issue with SQL Developer 4.1 Early Adopter 2 - start sql-script by "@"

thatJeffSmith-Oracle Apr 2, 2015 2:43 PM (in response to Matthias E. Müller)

@script.sql and executing with F9 or F5 both work for me - so something else is going on here.

As for the unprintable characters - what font are you using in 4.1 versus 4.0?
Like Show 0 Likes(0)

Actions
2. Re: Issue with SQL Developer 4.1 Early Adopter 2 - start sql-script by "@"

Turloch O'Tierney-Oracle Apr 2, 2015 2:52 PM (in response to Matthias E. Müller)

Try setting
Preferences->environment->encoding

Turloch
-SQLDeveloper Team
Like Show 0 Likes(0)

Actions
3. Re: Issue with SQL Developer 4.1 Early Adopter 2 - start sql-script by "@"

Matthias E. Müller Apr 28, 2015 1:41 PM (in response to Turloch O'Tierney-Oracle)

Hi,

with encoding set to utf8 it does not work. Don't know why. After setting the encoding to "cp1252" everything works fine again! Thank you very much!

Matthias
Like Show 0 Likes(0)

Actions

Go to original post