LPS-46172 Creates a new method to pass the default values
LPS-46712 Don't use deprecated methods
LPS-51018 Revert changes, this cause a Oracle regression. We cannot include in a DISTINCT a CLOB field