<?xml version="1.0" encoding="windows-1252"?>
<node id="490323" title="DBI prepare_cached" created="2005-09-08 17:08:46" updated="2005-09-08 13:08:46">
<type id="115">
perlquestion</type>
<author id="426097">
hok_si_la</author>
<data>
<field name="doctext">
Greetings Monks,&lt;br&gt;&lt;br&gt;

I use use DBI to execute my MS SQL server statements.  I recently read &lt;a href="http://search.cpan.org/~timb/DBI/DBI.pm#Database_Handle_Methods"&gt;Here&lt;/a&gt; that the method prepare_cached stores the statement handle in a hash associated with $dbh.  What is the scope of that hash?  Is it useless to use prepare_cached when a statement handle is not executed more than once within a given subroutine?&lt;br&gt;&lt;br&gt;

Thanks for your help&lt;br&gt;
hok_si_la</field>
</data>
</node>
