what code you have written in command on target?
in target #SQL_TEXT must work.
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 220.127.116.11, that i am using. Any thoughts or advice on this, other than suggesting me to contact 'Oracle support'. thank you. Sp.
What technology have you set in command on target?
what code you have written in command on target..?
technology : oracle
thanks for the follow-up.
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