Hello, I have several cases on client where the select from the query works as expected while when less conditions are set and more rows should be returned it locks and waits until I terminate it. On server the same script works fine! In sqlplus from clienr the query without WHERE works - there is 6050 rows selected. I wasn't able to find a test query from dual which do the same, sorry.
server: SLES-9 64bit with 9.2.0.4 and patch-9.2.0.8 installed DBD-1.19 build from sources client: Debian Lenny 32bit oracle instant client installed from aliened rpm 10.2.0.3 of instant client rpms (10.2.0.4 I tested also with same result) DBD::Oracle-1.23 compiled from source (also tried 1.19 from source and debian package libdbd-oracle-perl_1.21-2_i386.deb build from source) export ORACLE_HOME=/usr/lib/oracle/default/client/lib export LD_LIBRARY_PATH=$ORACLE_HOME export PATH=$PATH:$ORACLE_HOME/bin/ export TNS_ADMIN=/usr/lib/oracle/network/admin export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 files: test-case.pl - script I use to explain, work with condition, without condition it locks test-case.strace-ok - output of strace -o test-case.strace-ok perl test-case.pl with WHERE not commented test-case.strace-nok - WHERE is commented, partly fetched (only once works like that) test-case.strace-nok2 - WHERE is commented, locks before any fetch (every time) jiptdb_ora_23458.trc ok oracle trace file jiptdb_ora_23481.trc nok oracle trace file - partly fetched jiptdb_ora_27551.trc nok2 locked after execute install.log - script output from installing testing.log - script output from testing of ok and nok testing2.log - script output from nok2 thanks for any help as it is a real mystery for me. Radek Stastny
case.tar.bz2
Description: BZip2 compressed data