ERROR: type "varchar2" does not exist

[edgarSbGroup]

When running import foreign schema test_schema from server server_test into schema_test;
from an Oracle based system I get

[42704] ERROR: type "varchar2" does not exist

The script is trying to create a foreign table with varchar2

[MinhLA1410]

@edgarSbGroup , Thank you for reporting

jdbc_fdw has never tested with Oracle, so we can't provide any more information.
But here is limitation of jdbc_fdw
We are open to any suggestions and can consider them for future improvements.