Hi robert

Thanks for your reply... it works fine. Actually, I want to make sure that no such direct mapping of data type in Oracle is available.

Using function will solve my problem to some extent.

natrajv