Some rules of posting to a mailing list: Include error messages.
If there are no error message, describe the problem. This: > When I log in to sql plus we can > retrieve the > value, but cannot do so from perl. does not describe the problem. What does 'cannot do so from perl' mean? Scrambled data? No data? ?... Have you read the fine docs on DBD::Oracle and CLOB? $> perldoc DBD::Oracle You're using NCLOB. Is your NLS_DATE_PARAMETER set correctly? The fine oracle docs are at tahiti.oracle.com. HTH, Jared On Tuesday 29 October 2002 08:53, Rowe,Paul wrote: > 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"; > > 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 ---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: ----------------------------------------
