Editing and Compling a Database Package from a file
483412Aug 18 2008 — edited Sep 1 2008Hi,
I'd like to know if there is a way to open and edit a database specification and body source code file from the filesystem, and also be able to compile this is SQL Developer.
Currently I am able to open the .pks and .pkb files and I get 'Compile' and 'Compile for Debug' icons. However, when I hit these buttons they appear to do nothing. No messages are displayed to say if the package is compiled successfully or unsuccessfully. What I have noticed though is that the code is executed and the package is created on the database but there is no feedback. If I 'complile' a package that I know is invalid, the package becomes invalid in the database and vice versa. But I have no way of knowing this until I check the package on the database.
If I am doing something wrong or there is another way to do this, then please let me know. I really want to be able to work on these files from the filesystem rather than the database.
SQL Developer 1.5.1 on Windows 2000.
Cheers,
Jon.