PSQLODBC - Selecting bytea columns in Oracle

Hi,

I hope you can help. We have a PostgreSQL database which stores image data in bytea columns. I am attempting to read these images from within an Oracle database using the Oracle Database Gateway for ODBC and the PSQLODBC driver with the iODBC driver manager. However, the bytea column is being truncated to a single byte when selected within Oracle. I have attached the mylog_oracle????.log file plus the odbc.ini and odbcinst.ini. The software versions we are using are:

PostgreSQL database - 9.2.17
Oracle Database - 11.2.0.4
PSQLODBC driver - 9.5.3
iODBC Driver manager - 3.52.10

I have been working with Oracle Support for a while on this issue. Initially Oracle was displaying the bytea columns as a raw datatype with a length of 255 bytes. Oracle recommended setting the ByteaAsLongVarBinary to 1 in the odbc.ini file. This resulted in the bytea columns to be truncated to 1 byte within Oracle. Oracle have seen the log files and claim the data is being truncated within the ODBC driver.

Is there anything else I can try to resolve this issue so I can read all the data within the bytea columns from Oracle? Please let me know if I can provide any further information.

Many Thanks,

Regards,

John Robinson

John Robinson | Oracle Database Administrator
Vaisala Ltd, Information Services, Elm House, 351 Bristol Road, Birmingham, B5 7SW, United Kingdom
Tel +44 121 683 1237| Mobile +44 7739 874462
Email John(dot)Robinson(at)vaisala(dot)com<mailto:John(dot)Robinson(at)vaisala(dot)com> | www.vaisala.com<http://www.vaisala.com/>
Follow us on: Twitter<http://twitter.com/vaisalagroup> | Facebook<http://www.facebook.com/Vaisala> | YouTube<http://www.youtube.com/VaisalaGroup> | LinkedIn<http://www.linkedin.com/company/166747?trk=tyah>
P Please consider our environment before printing this email