Question on proC

is there some way of doing the following: I need to pass the name of sid and owner as a parameter for appending to table name for selecting data.
What I mean to say is

EXEC SQL SELECT COL1, COL2 from <owner>.table_name_at_<sid> ;

I wish to pass <owner> and <sid> as parameters. I would really appriciate some help in this matter since I have to figure out this in an hurry in order to support multiple SID's . We are on AIX , Oracle 7.1.3 and ver 2.0 of PRO*C.

Thanks
-P.

-- 
****************************************


**   Prashanth The Peasant            **

**   prashant_at_cs.pitt.edu	      **


**                           _        **