Pages

Thursday, October 28, 2010

Update Object Property

The General tab of object property can be used to store description, change documentations, etc. Often times I find myself not doing this until the end... It can take a while to go back and open each object to add the description. The following script automates the process by using the Project info for all objects in the project.

Tools v8.49.12.
--Update DESCR and DESCRLONG of Project Objects.
-- 1. set LASTUPDDTTM, LASTUPDOPRID To The same As Project
-- 2. append DESCRLONG
-- 3. set DESCR To Project If blank
---------------------------------------------------------------------------------
PS has 80+ object types, not all of them are listed here. Look for 'Unknown Object Type: ' and add a section for the object. Trace to see what objects PSIDE is accessing.
A nice & quick tracer app: Statement Tracer for Oracle