Pro*C -- How to pass a value into a Dynamic SQL (Method 3).

Hi there,

I got a problem about how to pass a value (NAME of table or column) into a dynamic SQL (method 3).

The following problem is a sample.

....

strcpy((char *) sqlstmt.arr,

   "SELECT distinct :col FROM :tab");
sqlstmt.len = strlen((char *) sqlstmt.arr);

....

EXEC SQL PREPARE S FROM :sqlstmt;

EXEC SQL DECLARE C CURSOR FOR S; EXEC SQL OPEN C USING :col_namei, :tab_name;

....

Is it possible to do this way ?

(In the programmer guide, P.9-13, " However, the names of database objects such  as tables and columns need not be specified until run time")

Thanks in advanced,

Yih-Feng Hwang