Re: run time change of columm

> i am using oracle 8.1.7.0.0 .it is possibel i want to change the 
columm name in storeprocedure at run time it is possible. becoz store 
procedure is not compile give me an error.any solution. becoz i want to 
cahnge the columm name at run time 

You have not given enough information for us to be able to help much.  
Show us:

1) The code that is failing

2) The Oracle error message

From what you have said, it seems you want to do something like:
SELECT xxx FROM my_table;

with xxx being able to have different values are runtime.

If so, that can be done using the "Native Dynamic SQL".  Refer to the 
PL/SQL Guide for more details:

http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/appde
v.920/a96624/11_dynam.htm#4376
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].