| Subject: | select statement via a database link fails on windows systems |
DBD-Oracle fails reproducible with an ORA-03113 error when I try to select data via a database link. The following error is reported:
DBD::Oracle::st execute failed: ORA-03113: Unerwartetes Übertragungsende in Kommunikation (DBD ERROR: OCIStmtExecute) [for Statement ...... ]
Oracle Client 9.2.0.1.0, Database Version 8.1.7.0.0, Windows XP SP2
No error is reported when I use a SQL-Plus Worksheet or one of the Ecplise plugins for a database connection on the same Windows system.
The query also works fine with DBD-Oracle on a Linux system.
Database link created with:
create database link hwdb connect to hwdbread identified by xyz using 'dbha32_itpd';
Query (or similiar):
select * from itpd.hw_system@hwdb;