Re: PRO*C PL/SQL PROBLEM!!!!!!

Jan Timmermans wrote:
>
> Hi,
>
> Can anybody outhere tell me how to refer to a column from which the name
> is only known at run-time. All the columns in the table, except for one, are
> added to the table after the pro-c program is compiled.
> The program only knows the name and the type of the column at runtime.
> I want to select the value from that column in a PRO*C program.
> I tried it with DBMS_SQL but this didn't work.
> Can someone show me exactly what to do ?
> Thanks,
>
> Jan
>
> --
> +---------------------------------+---------------------------------------+
> | Jan Timmermans | e-mail: jtimmerm_at_alpha.luc.ac.be |
> | Labo Toegepaste Informatica | tel : +032 011/268425 |
> | Limburgse Universitaire Campus | |
> | Belgium | |
> +---------------------------------+---------------------------------------+
There is a database table USER_TAB_COLUMNS that has all the column names, types, etc. for all the tables in a user's schema. Try querying from this table.

Ashok Kapur
akapur_at_thomtech.com Received on Tue Dec 12 1995 - 00:00:00 CET