I guess it depends on the RDBMS server. I would expect an implicit close, but I can imagine that the documentation states that it's unpredictable behaviour.
-- Peter. -----Origineel bericht----- Van:Bruce Johnson Verz.: 2012-07-01, 00:05 Aan: dbi-users@perl.org Ondrw.: Possibly Silly q Does a new execution of a cursor clear out any existing data or do I have to close the cursor? I have a situation where I'll step through a cursor, fetching rows and might break out of the loop before retrieving all the rows. Then the enclosing loop I'll execute the cursor with a new parameter. DO I have to do $csr->close(); ? or can I just do $csr->execute($param); again? -- Bruce Johnson "Wherever you go, there you are" B. Banzai, PhD
