Hi cjard,

Thanks for your reply.

I know, the DB desing is a mess. This is how it was when I came. I can not change the DB desing, several procedures are written based on the actual desing.

Somebody told me to write a PL/SQL, may you help me with that code?

Thanks.