help in dynamic query in Pro*C
Can i run the following query in Pro*C:-
EXEC SQL SELECT * FROM :tablename WHERE :attribute_name=:value;
i.e. this statement is embedded in C program and i want to supply table name (from which to select) and also the attribute name at run time only...is there any way to do this and is it first of all possible????????because till now what i have learned is that i can pass run-time values only into select list items and placeholders for input host variables... i have tried to implement it through cursors and descriptors but i have not been successful........please suggest some idea!!!
thanx in advance