Database Software

Hi,

I'm using this statement to change the filename for an external table definition, this works fine.
Is it possible to alter the external table location also and make it dynamicly and not only the filename?

alter table '||ext_table_name||' location('''||filename||'.csv'||''')';

Filename is a parameter in my procedure.

Thanks in advance.
CarolineB