Thanks for your prompt response. as stated in my previous msg, I tried with both the below options, but none of them worked
:SQL_TEXT (did not work)
#SQL_TEXT (did not work)
is there any other way of handling this ?
I was wondering if this is an bug/issue in version 18.104.22.168, that i am using. Any thoughts or advice on this, other than suggesting me to contact 'Oracle support'. thank you. Sp.
It will not work like that. you have to either store the variable value in other variable and then use that.
write command on source like
select pfg.table_owner SQL_TEXT1,pfg.table_name SQL_TEXT from TABLE_GROUP pfg , ALL_TABLES at
where pfg.enabled = 'Y' and pfg.group_name = 'TABLE_NAME' and pfg.table_owner = at.owner and pfg.table_name = at.table_name
command on target/ technology --> oracle
dbms_stats.gather_table_stats(#SQL_TEXT1 || #SQL_TEXT)
I have not try out this before but i believe it will work.
let me know