Hi,

Replace string

ALTER INDEX result rebuild tablespace tbs_name;

in your code with

execute immediate 'ALTER INDEX '||result.index_name||' rebuild tablespace tbs_name';

(If "tbs_name" in your code is a tablesapace name, not a parameter.)


Hope this helps,