On Wed, 2004-01-07 at 11:49, Wk0007-YDxpq3io04c@xxxxxxxxxxxxxxxx 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
|
