How to integrate project files into navigator window?

[jko]

Currently I'm about to move the development of our application out of the database and into the file system.

Unfortunately I have no idea how to "link" the database objects (packages, procedures and functions) to files in the file system.

So I read in the manual and found this nifty thingy called projects which seems to work like projects in other ides (like netbeans, eclipse, ...). Not sure if this is the proper way but I created a new project and added all my files from the file system (fnc, prc and pck) to this project.

Is this the suggested way? Or did I miss something essential?

If no, is there a way to integrate the projects files into the navigator for fast(er) accesss?

Thanks for any help.

 

[Marco Kalter]

Currently I'm about to move the development of our application out of the database and into the file system.

That's always a good plan. The easiest way to do this is to use the "Export User Objects" tool. Just select the program units you want to move to the file system, select "File per object", select an output file/directory, and press OK. You will now get a source file per object (file name = object name + default extension), and an overall script that you can ignore for this purpose.

 

[jko]

This is basically what I did (btw something for the wish list: a filter option for objects types would be handy, you can sort but it would be nice to be able to display only packages/package specs/package bodies when you have lots of tables and other objects).

Where I struggle is the point of file based development versus database based objects:

Attention: WALL OF TEXT

When I start the Developer I'm prompted to login to a database. After doing this I see the database objects in the navigator on the left. The navigator is omnipresent.

In other IDEs (not Oracle related) I create a project, choose a folder in the file system and add files. I'm able to browse the files, edit them, add new and stuff. After doing so, I upload or compile them. But all this is file system based.

In PL/SQL Developer the objects I see in the navigator are database objects and I don't know how to "link" them to a file in the file system, so figuratively spoken: opening a function f_foo would open f_foo.fnc instead of the database object. I doubt this is a good solution but I hope you see my "problem".

My solution (maybe it's the supposed way to do this) was to create a project, add all the exported files and work with the "project items" window from now on. What I'm looking for is a easier and more comfortable way to browse and handle this files: basically using the navigator window instead of a separate window or even [edit]worse[/edit]: dragging and dropping the files from Explorer to the Developer. But I can't dock the "project items" window somewhere and wasn't able to figure out how to add files to the navigator window.

Now my question is: am I doing something wrong or is it "as it is"?

 

[Sergey]

Using a projects is cool idea.
But next step is - to put objects/files into Version Control System.

In that case we need transitive links like this:
1. {Oracle objects, Files, Scripts} -> Project
2. {Oracle objects, Files, Scripts} -> VCS
And, we should be able to keep "Oracle's objects" from different schemas in one "Project".

 

[jko]

Marco could you add something more to this thread please?

Is it "as it is" or is there something I don't understand or doing wrong?

How are other users handling this?

/me is feeling a bit lost

 

[Marco Kalter]

It is "as it is". The Object Browser shows database objects, and files need to be opened from the file system, either directly or through a project.

In 8.0 you will have a File Browser similar to the Object Browser. This makes it easier to work either from the database or from the file system.

 

[jko]

Thanks for the reply. Looking forward version 8.0

 

[uzigula]

Hi, I do some test about VCS pluggin (I have SourceSafe 2005)

Well looking in prefenrences of the pluggin there is a option to Allow Version COntrol Over DB objects, and a proceed of this way.

1. Create project en VSS (VSS Project is a Folder)
2. Create a Project in PL-SQL Developers (PLProject)
3. Add Items to the PLProject
4. Add the same items in step 3 to VSS from Browser Object (save a copy of the object (SP, Function, Package) into local folder (local pc) and upload the file to the VSS Server.

with this i have link the objects of my project to the file on the disk and DB, seems to be work fine

Is it the correct way to do this?

 

[uzigula]

hello Guys
Well i have noticed a bug in the VCS pluggin in the option Checkout, in the window for checkout items, show the items with the incorrect icon information (no refresh the status of the files from VCS Server)
But the option UndoCheckout do this very well..

i Have a another question,
if i coud add objects to the VSS server directly from context menu Add to VCS option (work fine), can you create the option to do the same but for list of objects, and maybe in the next version integrate the object browser with VCS pluggin

thx

 

[uzigula]

hello

me again... i have a item to the wish list

in the Menu VCS of the pluggin can add the option "Refresh List of Files" or "Refresh Files" or something like that
the function will be update the list of files over the COntrol Version.

thx