Hello Hrishy

thanks for replying...so does it mean that i cannot make a small sort of search engine in Pro*C ......basically what i wanted was that the user will enter just the keyword to search for in the database and i will display him the appropriate tables in which that keyword is present....so for this i have to generate query myself in the code ......

and one more thing...can i store the name of a table in a variable and make
a query like this in pro*c:-
char * variable=tablename;
exec sql select * from variable where name='xyz';
i.e. 'variable' contains the name of the table to select from....