Re: What's a good tool for Stored Procedure/ Package development?

From: Lloyd Sheen <sqlguy_at_hotmail.com>
Date: Thu, 24 Oct 2002 17:01:24 GMT
Message-ID: <EHVt9.60709$mxk1.34653_at_news04.bloor.is.net.cable.rogers.com>


Check out SQL-Programmer from BMC software. Allows you to create and test and debug packages.

"Don Chambers" <dchamber_at_mindspring.com> wrote in message news:rfheru4d1pk5n75p87knn0aibbj9rjuvce_at_4ax.com...
> What development tools do you use to create Oracle Packages?
>
> We are currently using Oracle Enterprise manager but this is not a
> good tool for team development. With Enterprise manager you are
> connected to the database and actually editing the code in the
> database.
>
> This causes several problems:
> There is no source control or version control.
> With several developers creating and editing packages it's easy to
> accidently edit the wrong package. If this happens there is no way to
> undo the changes.
> We can't easily lock down completed scripts. Each devleoper does
> not have an individual account.
>
> Our process is to frequently update scripts (under source control)
> that are exactly the same as those in the database. Being a manual
> process we have lots of problems keeping the scripts in sync with the
> database.
>
> An additional problem is that when a change is required its very
> tempting to make the change directly to the database with the INTENT
> to updating the scripts. If the developer forgets to update the
> script we are out of sync.
>
> It would be great is we had a development environment that works off
> the file system with a way to sync with the database. When just using
> a text editor you can't 'compile' on the fly to ensure your syntax is
> correct.
>
> Does anyone know of a product with syntax highlighting and integrated
> compile that actually uses the fiels system to store your scritps?
>
> Don
>
Received on Thu Oct 24 2002 - 19:01:24 CEST

Original text of this message