Hi,
Am new to outsystems,I want to run a dynamically generated sql(in text format) in advance sql block but am not able to execute the same if i pass the text as parameter(@parameter) and then execute using EXEC @parameter.

did some one face similar issues?

Did you set the expand inline parameter property to true?

Note: Do not forget to use EncodeSql function to prevent SQL injection in the database.

Hi Andre,
Thank You for quick Turn around:).It helped:)
Thanks,
Nithin S C