Re: How to do this in ProC???

David Robert Dymm (dymmd_at_source.asset.com) wrote:

> An account consists of N number of tables. N is not known at compile
> time, but is the total number of tables in the account. The number, names
> and datatypes of the columns for each table are also not known at
> compile time. In a loop, for every table, fetch the table name,
> number of columns in the table, name of each column, and each
> column's data type. Also fetch every row in each table. Exit the
> loop when this information has been retrieved for every table in the
> account.

Use Dynamic SQL (Method 4 would work here I think) It is described in detail in the PRO C book that comes with Oracle

--
**************************************************************
*                          Saad Ahmad                        *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************