passing variable to a cursor

I would like to pass in a schema name to a cursor but I'm not sure what the syntax is, can someone help...

cursor mycursor (v_schemaname in varchar2) is

        select name from v_schemaname.emp where empid=100;

I've been getting ora-933:SQL command not properly ended.

thanks.

charlin Received on Thu Sep 08 2005 - 09:55:50 CDT