Thanks. Yeah the tabbed editor in PL/SQL Dev is really nice but I know Toad
and SQL Developer separate them. I can get used to it but my developers
might grumble though.
On Wed, Sep 13, 2017 at 12:27 PM, William Robertson <
william@xxxxxxxxxxxxxxxxxxxx> wrote:
Separate files for me too. You lose the tabbed editor window in PL/SQL
Developer but I don't really notice it.
William
On 13 Sep 2017, at 16:31, Michael Cunningham <napacunningham@xxxxxxxxx>
wrote:
Similar to what Norman said I use separate files and it is primarily due
to the way the TOAD development environment works. TOAD separates them, so
that's how I do it. Norman had a good point about being able to modify the
body without invalidating the package.
Michael
Sent from my iPhone
On Wed, Sep 13, 2017 at 8:00 AM, Jeff Chirco <backseatdba@xxxxxxxxx>
wrote:
We put all our database code in files and use a source control. We’ve
always stored our package header and body in a single file. We use PL/SQL
Developer and it handles that packages in a single file and opens the
header and body in nice separate tabs. We getting ready to move out source
control to Git and wondering if now is the time to split up our package
files into separate files. The benefit I guess is that we are not
compiling the header when nothing has changed. Currently when they made an
update to the package body the developers will send us the file containing
the header and so both get recompiled in production. Which unless I am
mistaken forces referencing objects to recompile. Only checking out the
body would prevent that but then we have more files to check out when we
need the header.
So I am curious what is better or more common? I’ve been also looking
around at tools that manage the source control like Datical and Red Gate.
Although Datical is ridiculously expensive. Anyways these tools seem to
prefer packages in separate files.
What does everyone here do?
Thanks,
Jeff
