Default Path from Tool Configuration not working

[Ivan C.]

Greetings!
I tried this in both, 9.0.1665 and 10.0.1.1694 (Windows 7 Pro, 64-bit).

I have a Tool defined for opening SQL*Plus, as follows:
9.0.1665:
===
General tab
---
Description: SQL*Plus
Type: External
Executable/Script: -- I have this pointing to a SQL*Plus shortcut in Start -> All programs, since I've edited the shortcut to display a different icon (.png), and I want my DOS (SQL*Plus) window to show the same icon in the upper left corner (rather than the black, command prompt icon)
Parameters: #connect
Default Path: #dir

Menu tab
---
Main menu: Tools
Sub menu:
Sub-sub menu:
Radio button set to At End

Button tab
---
Toolbar button:
Description: SQL*Plus
Image: -- I have this pointing to a .bmp file

Options tab
---
All of the check-boxes are not checked

10.0.1.1694
===
General tab
---
All the same as above, for 9.0.1665

Menu tab
---
Main menu: Tools
Sub menu:
Sub-sub menu:
Radio button set to At End
Image: -- I have this pointing to a .bmp file
Hint: SQL*Plus

Options tab
---
All of the check-boxes are not checked

Now the problem...
When I have a .sql file open in PL/SQL Developer (either in SQL Window, or in Program Window) I'm expecting SQL*Plus to open in the same directory as the file opened, since I specified #dir in Default Path option, during configuration (see above).
However, SQL*Plus opens in its "bin" (installed) location.

Also, in 9.0.1665 I'm able to add the SQL*Plus tool as a "Toolbar button". There's a check-box for that in the Configuration window, on the Button tab. This tab is missing in 10.0.1.1694, so I don't know how to add the button to my toolbar anymore.

Thank you in advance.
IC

 

[Marco Kalter]

I tested this and it works just fine. After starting the SQL*Plus tool I execute:

SQL> host cd

It shows me the directory of the file of the current window in PL/SQL Developer when SQL*Plus was launched.

About the toolbar button in 10.0: right-click on the toolbar area, select "Customize", click on the "Commands" tab page, select the "User defined tools" category, and drag & drop the SQL*Plus command to a toolbar.

 

[Ivan C.]

I found (I guess) what the problem is.
If I change Executable/Script value to point to the actual sqlplus.exe, not to a shortcut, as I've stated above, it works.

Here's the full path to the shortcut:
"C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Programming\Oracle - OraClient11g_home1\Application Development\SQL Plus.lnk"

Note: double-quotes of not makes no difference.

The issue with pointing to the actual sqlplus.exe is that I get the "plain old" (and boring) command prompt icon in the Task Bar and in the upper left corner of the SQL*Plus window.

It's an annoyance, since my SQL*Plus icon in Task Bar now looks just like any other Command Prompt.

Can this be fixed, please?

 

[Marco Kalter]

I don't think this can be fixed. The shortcut has its own default path preference ("Start in"), which overrules the path defined in the tool.