Thanks gurkha's but that dont seem to work in oracle 8i...maybe that works on higher version..anyone using oracle 8i..this shit is really frustrating.