Re: pl/sql code maintenance

John Hunter wrote:

> Tony,
>
> I always check the differences between the latest version in source control
> and what the production database contains. Most of the time they are the
> same, but if they are different then I find out from the developer what they
> were doing, why, why it's not in production etc... and determine from the
> answers which version (or combination of) to use.
>
> Hope this helps,
> -John
>
> "tony" <meinhfxGARBAGE_at_hotmail.com> wrote in message
> news:3e032190.1531610_at_news.dal.ca...
> > On Fri, 20 Dec 2002 08:03:31 -0500, "Jeff Smith" <jsmit234_at_ford.com>
> > wrote:
> >
> > >You have an accident waiting to happen.
> > >
> > >Code should be maintained OUTSIDE of the database using a version control
> > >software.
> > >
> > >
> > >"tony" <meinhfxGARBAGE_at_hotmail.com> wrote in message
> > >news:3e020177.16235514_at_news.dal.ca...
> > >> My question has to do with
> > >> how best to maintain code in all areas where there are several
> > >> developers / support people all working in each area. Since we can
> > >> retrieve the source from the databases it seems to me that there is
> > >> really no need to keep a current version of source thereby avoiding
> > >> the situation where developer a moves source from test to prod but
> > >> forgets to compile then developer b takes the source from prod back to
> > >> test to work on a bug.
> >
> > Thanks for all the replys. Perhaps I worded the question poorly
> > though because I don't think anyone really addressed it! We do have a
> > promotion procedure. We do have fully backed up version control.
> > What I'm asking is should we extract the source from the database
> > rather than assume that the apparent, current version is in fact what
> > was last compiled? Is the ability to
> >
> > select text
> > from sys.dba_source
> > where name = 'PLSQLCODE'
> > and type = 'PACKAGE BODY'
> > order by line;
> >
> > not something we should be using to ensure we're working with the
> > correct version?
> >
> > tony

Developers should never have access to any test or production database for any purpose other than to perhaps run an occassional explain plan or observe something (read only) that is misbehaving.

If there are developers in a test or production database ... the DBA isn't doing the job the DBA was hired to do.

Dan Morgan Received on Fri Dec 20 2002 - 17:26:54 CST