Hi All,
OK, now I have a really weird problem. It didn't seem to happen before but
now...
I'm building an application on Solaris using Oracle 8i, Perl 5.6.1, DBI on
Apache with mod_perl and Apache::DBI (). I've discovered that somewhere
along the line, one of these components seems to be caching the results of
SQL returns... I am using almost completely all stored procedures in
packages on the Oracle database, and using
$sth->prepare("procedure-definition") and $sth-bind_param("param_name",
$\perlvar) $sth->execute to get my results.
The strange problem is that I can go and delete records that I've added, but
from within the perl code, that data still shows up in the queries! Then
when I go to SQL+ command-line Oracle program, the same queries return no
records for those I've deleted.
I'm not sure if DBI is caching the results or what, but it is getting very
frustrating! Does anyone have any insight into this phenomenon?
Many, many thanks in advance. Sincerely,
----------------------------------------
Hugh J. Hitchcock
Sr. Software Engineer / Project Manager
Tiaxa, Inc.
http://www.tiaxa.com
