You are fetching an Oracle LOB locator. I am not a guru of OCI let alone JDBC but AFAIK you should create a LOB descriptor, bind it to the locator and load the LOB data that you can insert into postgres.
- [GENERAL] Read a CLOB data from an Oracle table and IN... SHARMILA JOTHIRAJAH
- Re: [GENERAL] Read a CLOB data from an Oracle tab... Vyacheslav Kalinin