Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Version control for PL/SQL. Which is the best approach?

24631Oct 4 2001
We are developing a quite complex system which involves several
pl/sql packages, some triggers and stored procedure. We have a
version control system (StarTeam) in which we can store the
history of each change at our pl/sql code.
The problem is: which is, in your opinion, the best way to "mark"
a version in pl/sql? For example I putted a costant in a package
interface named "Version=1" which I increment for each new
release; but what about trigger and stored procedure? I need a
system, as simple as possible, which allows a customer to query
the database and tell us "which version" of the overall system
(package+trigger+proc) he/she has.
Thanks in advance
Nicola Farina
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2001
Added on Oct 4 2001
4 comments
415 views