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

Don Chambers wrote:

> 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

From my standpoint ... vi or notepad.

If you are looking for an editor that color codes and all that stuff there are a lot of freeware/shareware products out there ... one I like is WinEdit for the Windows environment but in truth I rarely use as I don't need the colors and the other bells and wistles.

Daniel Morgan Received on Thu Oct 24 2002 - 10:15:50 CDT