Hi,

Is there any way I can pass the database name (dblink) as the parameter into the PL/SQL procedure so that I can create cursor for a table which would be there in the different databases ?

Databases : abc, xyz
Tablename : findit

If the parameter is 'abc', then I will issue

Create or replace procedure aaa ( mmm in varchar2)
Cursor xxx is
select * from findit@mmm

- which should eventually pick from findit@abc.

Thanks