Re: Pro*C --- How to pass a value into a host variable !!
From: 170 Systems <170sys_at_netcom.com>
Date: Fri, 24 Mar 1995 14:22:38 GMT
Message-ID: <170sysD5y7xr.G9r_at_netcom.com>
Date: Fri, 24 Mar 1995 14:22:38 GMT
Message-ID: <170sysD5y7xr.G9r_at_netcom.com>
Yih-feng Hwang (CS 688) (yhwang) wrote:
: I have a problem about how to pass a value (string) into a host variable
: ( :name_of_table and :name_of_attribute) in a SQL (listed below)
: EXEC SQL SELECT *
: FROM :name_of_table
: WHERE :name_of_attribute;
You need to use Method 4 dynamic SQL. See the "Programmer's Guide to the ORACLE Precompilers".
- Dan