Re: PRO*C PL/SQL PROBLEM!!!!!!
Date: 1995/12/12
Message-ID: <4akb92$ltq_at_thorn.cc.usm.edu>#1/1
Jan Timmermans (jtimmerm_at_alpha) wrote:
: 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 ?
I can't show you exactly what to do, but I can make a suggestion based on
what you've said here. Correct me if I am misreading though.
Column(s) are added to a table after your Pro*C program is compiled. Is this a normal process? if so, how about adding a lookup table -- when a new column is added, also add a row to your lookup table. Then your c program can query the new column name from the lookup table.
Depending on your actual situation, this may or may not be feasible. I hope you find out what you need to know.
Jonathan Received on Tue Dec 12 1995 - 00:00:00 CET