On Wednesday 30 October 2002 07:08, Jared Still wrote: > > You're using NCLOB. Is your NLS_DATE_PARAMETER set correctly? > > The fine oracle docs are at tahiti.oracle.com.
NLS_DATE_PARAMETER? Must have been a brain fart, that has nothing to do with it. What I should have mentioned were the NLS_LANGUAGE and NLS_TERRITORY database parameters, and the corresponding NLS_LANG environment variable. Jared > > 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: > ----------------------------------------
