On Tuesday, May 1, 2012 8:41:37 AM UTC-4, jeremy wrote:We also just use manual tools to make pl/sql and sqlplus script changes. For our official source for database objects we store after images of the code. That is each time a table is altered (column added, index added, etc) or a package is modified we generate a new code listing via home-grown dictionary extract (generate DDL) scripts and store the new source in sccs.
> Hi just wondering if anyone could shed any light on good tools for
> managing the build and release of PL/SQL-based applications.
> We are using SVN and a mix of SQL*Developer & PL/SQL Developer & Textpad
> We manually build scripts for DDL changes for each release and manually
> We use SVN branches/tags for each release but have to eb able to apply
You can diff the most recent source file verse the previous version to determine the change made. Developers are required to provide the DDL to apply the change to system test and later production.
All object DDL that are dropped by Oracle when you drop a table are stored as part of the table source while independent objects such as functions, procedures, packages, and sequences have their own source members.
HTH -- Mark D Powell --
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.