On Wed, 2004-01-07 at 11:49, [EMAIL PROTECTED] wrote: > I've beem frustrated by the following error message when I run a script > on an Oracle database: > > 'DBD::Oracle::st execute failed: ORA-01000: maximum open cursors exceeded > (DBD ERROR: OCIStmtExecute) [for statement "DELETE DATA_TM WHERE > EXP_ID = 1396" with params: ]) at ./analyse_data.pl line 637.' > > Can one of you experts out there give me a pointer on how to close open > cursors in Oracle?
This often happens when you have too many active prepared statements at once. Are you using $dbh->prepare() and if so, how are you managing the resultant statement handles? -- Jeremy _______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm
