Please read alian as alias
2 of 2 people found this helpful
Several problems here:
You cannot use variables (%crs_home%, %db_unique_name%) in a 'constant' block
After moving this to the body section, there are some other problems.
You will need to assign values to crs_home and db_unique_name before you can use them assignment to dbname_command variable. You can probably get these from the ora_si object.
For testing purposes, set the use the log.info command rather than the log.debug command. You will not see these in the output logs unless your logs are set to debug, and the you get too much information to run through.
I recommend putting some sort of delimiter around the variables you are trying to view in the log statements, something like this:
log.info('***PatternName : dbname_command output : -->%db_nameraw.result%<--');
this way you can tell if there is 'nothing' in your output vs 'whitespace'