Re: Dynamic SQL

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!