macro within procedure

Database
Enthusiast

macro within procedure

Hi,

i am trying to call a macro inside procedure.
But getting following error.

SPL1027:E(L16), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between the 'THEN' keyword and the 'Execute' keyword.'.

can u please suggest me on this.

Regards.........
Gander