Using host variables with cursors

I'm trying to use a cursor like this...

Exec sql declare cursor for select * from :table_name;

but it gives me an error at :table_name. Is there a reason that I can't use a variable here? Is there another solution?

BB Received on Sat Feb 23 2002 - 19:42:06 CST