I want to store the latest build number and date in the comment header section of my Oracle Procedures. I have searched on this topic but have only found storing dates and number in tables and not what I need.
Back story - in the middle of a botched deploy I had to file diff procedures to confirm the latest and greatest was deployed as expected. We have grown from a start up to more of an enterprise and are trying to get better processes in place. Most of our procedures do not have headers and developers do not often add modifications/dates to them. I want to update a build version and date in the comment header as a result of the deployment action. We are using Hudson to automate deploys. I believe I should be able to add something to the header and update that via Hudson during the deploy. Then, confirmation that the latest and greatest is there would be at a glance instead of having to wade through a file diff.
I have used Google and searched other sites to no avail. Any help would be greatly appreciated.
Thanks!