Re: (Toad) SCC API & PL/SQL

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 9 Jun 2005 11:27:18 -0400
Message-ID: <OdmdnWTzCb9EwjXfRVn-2Q@comcast.com>

"Martin T." <bilbothebagginsbab5_at_freenet.de> wrote in message news:1118330582.641983.92530_at_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

>

actually, i think its 'Team Coding' tables that Toad has

++ mcs Received on Thu Jun 09 2005 - 10:27:18 CDT