Re: Question on proC

nivst+_at_pitt.edu (Nithya Vaidyanathan) writes:
>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.

This should be a FAQ (what happened to it?).

Use dynamic SQL. Look in the dynamic SQL chapters of the manual, where there are some examples that show how you can do this.

--Tim (tssmith_at_netcom.com) (tssmith_at_oracle.com) Received on Sat Sep 10 1994 - 02:54:58 CEST