Re: (Toad) SCC API & PL/SQL

"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.
>
> So, any ideas ?
>
> Better tools that also suport SCC API?
>
> thanks!
> best regards,
> Martin
>

database event triggers that check the TOAD SCC tables, ie.:

CREATE OR REPLACE TRIGGER trg_vcs
before create or alter or drop on schema begin

• your code goes here; raise exception if object is not checked out end; /

++ mcs Received on Thu Jun 09 2005 - 06:26:11 CDT