Pando:

Thanks for your input. I also have used the same to_date function in procedure. Then Informatica can call that procedure. In the begining, I thought that the datatype of Modification_date column was date (19). So I do not need to format it. While the date format in Informatica is 'mm-dd-yyyy'. I tried to format Oracle date into 'mm-dd-yyyy' to match up with Informatica. It didn't work. This was why I posted on line for help. Anyway, thanks for your help. After I turn back to think it over, it is really not hard.