Hi, Please suggest what is wrong in following query? SELECT CATEGORY_ID FROM CATEG WHERE CATEGORY = :b1 thanks _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement -- //www.freelists.org/webpage/oracle-l