How to questions

[Zohar Elkayam]

Hey,
I'm not a new user to this application - I've been using it for the last couple of years but recently I got to use it more often and I must say it's one of the more likable program I ever used...

Anyhow, I got couple of things I couldn't find on the menus or in the forum and I'll be happy if someone could help me out:

1. When editing packages and package bodies, I would like to have the owner's name as a prefix to the package name. Even if I compile it with the schema name, it still resets after closing the window and re-opening it from the bar on the left side.

2. I know there is a "Save layout" option on the menu (and I can also make it automatic), but how do I LOAD a layout?

3. Is there any way I can use multiple connections to multiple database at the same time with one PL/SQL Developer window?

Thanks a lot!
Zohar

p.s
I'm using version 7.0.0.1050

 

[Marco Kalter]

1. When editing packages and package bodies, I would like to have the owner's name as a prefix to the package name. Even if I compile it with the schema name, it still resets after closing the window and re-opening it from the bar on the left side.

When you open a program source from the database, the owner prefix will be omitted when connected as the owner. To preserve this kind of information, you will need to save the source to a file and work with that file instead of the database source.

2. I know there is a "Save layout" option on the menu (and I can also make it automatic), but how do I LOAD a layout?

The layout is loaded when you start PL/SQL Developer.

3. Is there any way I can use multiple connections to multiple database at the same time with one PL/SQL Developer window?

No, multiple connections require multiple PL/SQL Developer instances.

 

[Zohar Elkayam]

Thanks for your reply!

That's a pity... What I did until now (using mostly TOAD), was editing and compiling my database object as much as I liked and then saved it into files when I was done. I did it from several machines so the most current version is only on the server.
It's a pity I can't do that with PL/SQL Developer.

By the way - is there a way I can save edited spec and body from the database into two different files (the spec in one and the body in another)?

2. If that is so, the save layout doesn't work here... I tried to save my layout several times but I didn't get it back when I started the PL/SQL Developer again. That happened only if the PL/SQL Developer was closed brutally.

Regards,
Zohar Elkayam

 

[Marco Kalter]

By the way - is there a way I can save edited spec and body from the database into two different files (the spec in one and the body in another)?

There is a "Save Separate" Plug-In. You can find it on the Plug-Ins page .

2. If that is so, the save layout doesn't work here... I tried to save my layout several times but I didn't get it back when I started the PL/SQL Developer again. That happened only if the PL/SQL Developer was closed brutally.

You probably want to use the "AutoSave Desktop" preference (Tools > Preferences > User Interface/Options).

 

[townsendEbmud]

As far as editing from different machines and having different source files, the Oracle File System feature would resolve that problem. The files are stored and accessed from the database, so are available anywhere a database connection can be made. (Theoretically; I haven't actually used the feature yet)