Tim (and others), This one has me rather stumped.
If you use the example test case (probably modified to meet your needs), then it is dying in the following manner: .... blah blah blah ... 50: SYSBHA.BUS_SITE_SMRY - 0 51: SYSBHA.BUS_SITE_SMRY_T - 0 52: SYSBHA.CALC - 1 53: SYSBHA.CALL_DELETE - 0 54: SYSBHA.CALL_STATS - 2 (SYSBHA.CARRIER) ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded (DBD ERROR: OCIStmtExecute/Describe) at oratest.pl line 16. If you comment out the marked line then it runs through to completion. Anyone seen it or can guess what might be causing it to occur? Here is the output from sqlplus ------------------------------- SQL*Plus: Release 8.1.7.0.0 - Production on Fri Nov 30 13:51:15 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production The test machine is WinNT 4.0 SP6a. The build machine is W2K SP1 with Oracle 8.1.6. Build environment is Visual C 5.0 (no SP). Perl was built from scratch from the std perl-5.6.1 distribution. This error occurred on DBI 1.12/Oracle 1.07 and DBI 1.20/Oracle 1.12. Attached is also the make outputs as instructed in the README from DBD::Oracle Regards, Andrew
oratest.pl
Description: Binary data
make.out
Description: Binary data
