Skip to Main Content

Database Software

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!

tcl-omb command to exclude names from a file

birdyOct 19 2011 — edited Oct 28 2011
Hi

I am writing a tcl script where
1. I accept a module name as input for a current project.
2. after this I check for whether a config file exists for that module in a particular location and I then store the value in a parameter. this config file contains a list of object names to be excluded during deployment
3. For that particular module, while deploying objects(mappings and plsql transformations), I want to check the config file above against the list of objects I retrieve for that module and exclude the ones in the config file from deployment process

can someone please tell me how can I achieve the 3rd part


Basically I want to modify the below block if possible. Hope this helps

my oracle module parameter is oraclemodulename
my config parameter is p_exclusion_file

code to deploy is

set objList [ OMBLIST $object_list]
foreach objName $objList {
set deployAction [OMBRETRIEVE $objectType \ '$objectName' GET PROPERTIES (DEPLOYABLE)]
if {$deployAction == "true"} {
puts "deploying [string tolower $object_type]... $oraclemodulename/$objName"
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN\
'DEPLOY_PLAN'\
ADD ACTION '$object_type\_DEPLOY' SET\
PROPERTIES (OPERATION)\
VALUES ('CREATE') SET\
REFERENCE $object_type '$objName'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
set OMBCONTINUE_ON_ERROR true
OMBDROP DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
OMBCOMMIT
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2011
Added on Oct 19 2011
5 comments
383 views