OMBDEPLOY from TCL Script does not show Errors and Warnings
Hi
I am trying to deploy a table from the OMBPlus command prompt.
The table already exists in the database and I am getting a error/warning message when I am running this from the OMB+> prompt.
And I am also able to see the error messages from the OWB Control Center Manager as well.
ORA-00955: name is already used by an existing object
But, When I do the same thing using the TCL script, It is not showing any error.
In the script I have put the OMBDEPLOY command in catch block as follows, but still it does not show any errors.
--------
....
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN 'TREX_DEPLOY_PLAN'
....
OMBALTER DEPLOYMENT_ACTION_PLAN 'TREX_DEPLOY_PLAN' ADD ACTION 'TREX_TABLE_PLAN_$tableName' \
SET PROPERTIES (OPERATION) VALUES ('CREATE') SET REFERENCE TABLE '$tableName'
....
if { [ catch {
puts "Deploying .."
puts $out "Deploying .."
OMBDEPLOY DEPLOYMENT_ACTION_PLAN 'TREX_DEPLOY_PLAN'
OMBDROP DEPLOYMENT_ACTION_PLAN 'TREX_DEPLOY_PLAN'
OMBCOMMIT
} errmsg ] } {
puts "Error while Deploying module '$moduleName' .. : $errmsg"
puts $out "Error while Deploying module '$moduleName' .. : $errmsg"
} else {
--------
Can you please let me know how to enable error messages when I run from the TCL script as well ?
Is there any OMB API to fetch errors when our statements are executed ?
Or will there be any setting to enable it ?
Thanks and Regards
Sameer