Tim, sorry to bother you but after searching
through the cpan and perl-org docs
I cannot find a
solution to my problem. We are attempting to retrieve a nclob value from
an Oracle 8i
database and cannot do so. When I log in to sql plus we can retrieve
the
value, but cannot do
so from perl.
We have the Oracle
1.12 DBD installed on a solaris 2.6 installation, running perl
5.6.1.
The sequel we are
executing for test purposes is:
my $sql3 = "select
attribute_value_txt from asset_attributes where asset_surrogate_id = 41 and
attribute_typ = 29";
my $sth3 = $score_dbh->prepare($sql3) || die new AGG_Exception(-message => '2.2', -details => "sql: $sql3 -- $DBI::errstr : $!");
$sth3->execute() || die new AGG_Exception(-message => '2.3', -details => "sql: $sql3 -- $DBI::errstr : $!");
my $test = $sth3->fetchrow;
chomp ($test);
print PJR "THE TEST RETRIEVAL IS $test\n";
my $sth3 = $score_dbh->prepare($sql3) || die new AGG_Exception(-message => '2.2', -details => "sql: $sql3 -- $DBI::errstr : $!");
$sth3->execute() || die new AGG_Exception(-message => '2.3', -details => "sql: $sql3 -- $DBI::errstr : $!");
my $test = $sth3->fetchrow;
chomp ($test);
print PJR "THE TEST RETRIEVAL IS $test\n";
The field
attribute_value_txt is a nclob. When we change this field to another in
the table, other than the nclob, we can
retrieve without
problem.
Any help you could provide would be greatly appreciated.
Thank you,
Paul J. Rowe
Gartner
Interactive Technology Group
80
Holtz Drive, Suite 100
Cheektowaga, NY
14225
Phone: 716-633-0720 x217
Fax: 716-633-9506
