Home -> Usenet -> comp.databases.oracle -> Host Variables in PRO*C

Host Variables in PRO*C

From: Christopher R Heroux <herouxch_at_caspian.uucp>
Date: 5 Jan 1994 06:21:30 GMT
Message-ID: <2gdm9a$ujl_at_msuinfo.cl.msu.edu> 






Is there a way of using host variables for table names and for variables in
select statements?  Something like:


            EXEC SQL SELECT  :column
                INTO  :value
                FROM  :table   
                WHERE YEAR = :year;





I'm working with a large number of tables and variable columns and
my code is getting mighty long.



Thanks,



Chris Heroux

--
   _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
  _/  Entomology Spatial Analysis Laboratory  _/
 _/   E-mail: herouxch_at_cps.msu.edu           _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


Received on Wed Jan 05 1994 - 07:21:30 CET












Original text of this message