-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: OLDB - ODBC
Does this belong in the DBI list? Sorry if the answer is yes.
*****************
Hi,
We have a problem. We run Perl for Window NT. We use Perl to read
ASCII Files, and write the information to a Database.
Some of these fields are longer than 32,000 characters long. We just
had
one that was 86,000 characters long.
The problem we have is that our driver is limited. It can't handle
86,000 characters. We needed to trim the length to 32,000 because we
often had ASCII characters that were bigger than the normal size. We
settled on 32,000. But now the department wants to get the whole record.
The database can definitely hold that big of a variable. The problem is
getting there with the limits of the driver that we are using.
************************************************************************
**
** Here is a piece of the code of opening the driver.
use Win32::Registry;
my $Register = "Software\\Sparq\\CLDSN_DEV";
my $RegType, $RegValue, $RegKey, $value;
my %values;
$HKEY_LOCAL_MACHINE->Open($Register,$hkey)|| die $!;
$hkey->GetValues(\%values);
foreach $value (keys(%values))
{
$RegType = $values{$value}->[1];
$RegValue = $values{$value}->[2];
$RegKey = $values{$value}->[0];
if($RegKey eq "Name")
{
$Database=$RegValue;
$FullDatabase = "dbi:ODBC:$Database";
}
}
$hkey->Close();
************************************************************************
*********
The program with ODBC well and has been working for over a year. This
issue has just come up.
Is there an extension in ODBC that will be able to handle 200,000 bytes
in one shot. Or perhaps another extension that is similar to OLDB?
The Databse is: Oracle8i Enterprise Edition Release 8.1.5.0.0 -
Production
PL/SQL Release 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Thanks.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
**** DISCLAIMER ****
"This e-mail and any attachment thereto may contain information which is confidential
and/or protected by intellectual property rights and are intended for the sole use of
the recipient(s) named above.
Any use of the information contained herein (including, but not limited to, total or
partial reproduction, communication or distribution in any form) by other persons than
the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender either by
telephone or by e-mail and delete the material from any computer".
Thank you for your cooperation.
For further information about Proximus mobile phone services please see our website at
http://www.proximus.be or refer to any Proximus agent.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
