Paul Van Deursen wrote: > > I had the same problem on a NT 4 machine. > I say had because all my problems disappeared after I made all the > statement handle names unique. > > I used to create $sth and call finish afterwards and create a new $sth > which gave me that famous error. > After I renamed them to $sth1, $sth2 etc. (in the same subroutine) this problem >disappeared. > It seems that even after a finish() call the statement handles stay active > but I don't have a clue why.
There should be no need to call $sth->finish unless you didn't retrieve all records from handle. In any case, to destroy a statement handle use `undef $sth` - there should be no need for new variable names. Ryan, let us know if it fixes the problem. -- Simon Oliver