Thanks Sasha, your sugestion with EXECUTE STATEMENT solved my problem.
Thanks also to Martijn Tonies.

var_sttm='SELECT DISTINCT year,month FROM '||:pTBL

FOR EXECUTE STATEMENT var_sttm INTO :year,:month
DO BEGIN SUSPEND; END
END;




sasha <selectnull@...> wrote: >

> HI ! I want to create a SP and send table name as
> parameter,but it doesn't work .
> Is any solution,thank a lot !
>

You can not use parameter as a table tame but you can do it with execute
statement. Look it up in release notes.

Sasha






---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.

[Non-text portions of this message have been removed]