Greetings DBI Users,
I am having an intermittent problem which has increased in frequency. Googling the output doesn't provide any answers, or even evidence of other people with the same question.
When I pull from a table containing a CLOB column, sometimes, I don't get the CLOB data, and instead I get this:
OCILobLocatorPtr=SCALAR(0x40468100)
This never happens on our linux server in the office. It happens frequently on our client's beefy HP-UX server, and it happens every time on their weak staging server, also running HP-UX.
The application in question is a CGI script. Different paths through the script can cause different queries to fail. Other script which manipulate different tables do not appear to fail, though they are written in a similar manner.
When I realized that this was an internittent problem, I modified the code to retry if the error happened, and to print out $dbh->errstr. But there's no error string returned.
I could realy use any sort of pointers you could give me on tracking this down. Code snippets below.
--Sean McMillan
my $parentmessage = $dbh->selectrow_array(q[
select body
from sk2_discussion
where PostCode = ?
], {}, $parentcode);
if (ref($parentmessage) eq 'OCILobLocatorPtr') {
my $tmp = $dbh->errstr;
$parentmessage = "Unable to retrieve message body <!-- $parentmessage $tmp -->";
}
