in reply to Re: Question About Proper Use of Bind Variables in Perl DBI Scripts
in thread Question About Proper Use of Bind Variables in Perl DBI Scripts

It does, but I think it only keeps a certain number cached. If a particular query is run enough, it will be cached, but this is very dependent on use of the database. If there is a lot of activity, you need to run your query many times before it will be cached in the DB.

The advice above allow you to reuse the prepare on the Perl side without counting on Oracle to do it.

  • Comment on Re^2: Question About Proper Use of Bind Variables in Perl DBI Scripts

In Section Seekers of Perl Wisdom