Heterogeneous Connectivity :: HS To Postgre ORA-28511

select from the postgre databse works just fine (however when i select data column alone it returns as date, if i select it together with som condition in where clause it returns varchar).

-- this runs ok
select
t."idbill",
t."idpoint"
from "crm"."bills2points"@dl_carecloud t
,"crm"."bills"@dl_carecloud brg
where 1=1
and t."idbill" = brg."idbill"
and t."idbill" = 9685;
[code]....