Re: Dynamic SQL
From: Ronald <r.goeggelNOr.SPAM_at_atos-group.de.invalid>
Date: 2000/04/27
Message-ID: <0de6b490.c4ae017c_at_usw-ex0101-007.remarq.com>#1/1
Date: 2000/04/27
Message-ID: <0de6b490.c4ae017c_at_usw-ex0101-007.remarq.com>#1/1
Pro*C Method 4: How can I refer to bind variables
I can't find any documentation how to refer to bind variables in an SQL statement.
I studied sample10.pc. So I am able to fetch the whole table. Then I initialized bind variables, but I have no idea how to format a SELECT statement.
On INFORMIX it looks like
"SELECT * FROM table where field1 = ?"
INFORMIX replaces this "?" by the first element of the SQLDA
array
How should I do this in ORACLE?
Thanx in advance
Ronald
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!