Open only one instance of "PL/SQL Developer"

[rwolus]

Hi,

I use "PL/SQL Developer" in 7.1.5 version and Windows 7.
I have associated files type ".sql" with "PL/SQL Developer".

I have the following problem:
- I open "sql" file by double click and new instance of "PL/SQL Developer" starts.
- Then I open another "sql" file by double click and new instance of "PL/SQL Developer" starts.

Each open ".sql" file, starts new instance of "PL/SQL Developer".

How can I change it ? I wish to open each "sql" files in same instace of program.

 

[Marco Kalter]

This is a Windows Explorer issue. Can you go to Tools > Preferences > Files / Extensions, press the "Register file types" button and register the extensions? Verify if this helps.

 

[rwolus]

Thanks for answer but I use Windows 7 and
I don't see this options in Windows Explorer.

 

[Marco Kalter]

This is in PL/SQL Developer.

 

[rwolus]

Ok, I used this option "Register file types" but It changed nothing.

Still each "sql" file open in new instance of "PL/SQL Developer"

 

[Marco Kalter]

Can you try the same with 8.0?

 

[rwolus]

No I can't becouse I can use only 7.1.5 version in our company.

I have this problem only on Windows 7 (on Windows XP is ok).

Maybe it depends on some Windows settings but I can't find any info about it.

 

[Frank Kintrup]

Registering the filetype in PL/SQL-Dev sometimes does not work.
If a program directly calls plsqldev.exe with the filename as parameter (instead of using Shellexecute with the filename) you always get a new instance of Pl/SQL-Dev.
This is VERY annoying, could you please fix it by "transferring" the filename to the running instance? I guess almost no one would want a new instance except when starting a new instance from the file menu.
Thanks!

 

[Bernhard S]

You could use drag and drop of the sql file from explorer window onto the running PL/SQL-Developer instance. This works also with multiple instances open, where PL/SQL-Developer cannot decide anyway which running instance you mean.

 

[Maxmix]

I always have many instances running, so it would be a catastrophe if the instance to host opened file would be elected at random.

 

[Gerf]

I solved this problem in Windows7.

In Windows XP it is simple(folder options ->file types -> advanced...), but for Windows7 I had to use program "filetypesman".
You need register ".sql" filetype with DDE instructions for action "open":
Message: [Open("%1")]
Application: PLSQLDev
Topic: System

It is very useful for me. I can quickly open SQL|TEST from shortcut in toolbar (configuration in "Tools->Configuration Tools") in open instance. And I also use many instances running and had no problems with such configuration.