I have a view that utilizes the native Oracle Add_Months function in the criteria portion of the select statement. This view works well in our 8i environment, however we are migrating to 10g. There, the view fails to return any data if the Add_Months function is not remarked out. If it is remarked out, then the view returns appropriate data. Does anyone have any idea why?