Execute Immediate error !!

[thomasp]

Re-write your sql stmt as

OPEN cv FOR
 'select index_name from dba_indexes where table_name = ''' || table_name ||
 ''' and status = ''UNUSABLE''';