v9 sql files now open command window instead of sql window

[cassiusdrow]

Under version 8, if I drag and drop a file with the extension ".sql" to PL/SQL developer, it would open in an sql editor window. Under version 9, it now opens in a command editor window. Is this expected? If so, is there a preference to control this behavior?

Under Preferences, Files, Extensions, all values are defaults. I also have the multiple connections feature disabled, but session mode is multiple sessions.

 

[Marco Kalter]

Version 9 will recognize that the file starts with one or more SQL*Plus commands and will then open it in a Command Window. Can you confirm that this is indeed the case for this file?

 

[cassiusdrow]

You are correct. It only happens with files that begin with SQL*Plus commands.

Is there a setting to change this behavior? Our group never uses the command window in PL/SQL. While we author SQL*Plus scripts in PL/SQL Developer, we only test them in SQL*Plus because that is how they will be run in production or by the change implementers.

 

[Marco Kalter]

There is currently no option to overrule this, but I have added this to the list of enhancement requests.