Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: (Toad) SCC API & PL/SQL

Re: (Toad) SCC API & PL/SQL

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 9 Jun 2005 08:23:02 -0700
Message-ID: <1118330582.641983.92530@g47g2000cwa.googlegroups.com>


Mark C. Stock wrote:
> "Martin T." <bilbothebagginsbab5_at_freenet.de> wrote in message
> news:1118312821.985682.45410_at_z14g2000cwz.googlegroups.com...
> > Hi there.
> >
> > We use Toad for writing PL/SQL on our Oracle DB.
> > Toad's SCC API allows for integration with source code control SW.
> > The problem we see is that to work with source control, every time a
> > developer works on a procedure, the procedure has to be saved as a
> > local file to be versioned via SCC.
> > Since a developer can edit/compile a procedure via Toad without saving
> > locally, this will sooner or later result in someone doing changes
> > without checking them in into source control.
> >(...)
>
> database event triggers that check the TOAD SCC tables, ie.:
>
> (...)

Hm. Toad SCC tables? I'm not aware that toad does any database entrys for the SCC API integration ...

But the script thing ... I think it should be possible to have a trigger calling a script that creates a new version in the VCS system every time a package is updated.
Would this be a good idea? That way the source control would be client independent ...

thanks for your tip,
best regards,
Martin Received on Thu Jun 09 2005 - 10:23:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US