Hi there,

  i'm using DBI 1.18 and DBD-Oracle 1.06 on HP-UX 10.20 to connect to a 
remote Database running Oracle 8.1.7.1.0. I get a "out of memory" error 
while selecting from a large Table. I've tried to limit the 
RowCacheSize, but still i get this error. The script does nothing like 
prepare "Select * from tablex", execute the corresponding handle and 
then fetches the results in a loop (while fetchrow()...). The results 
are not stored, so there is no (so much) memory-usage by the script 
itself. While running the script the Memory-usage increases till the 1GB 
UserLimit is reached and then get an "Out of Memory" error (i guess from 
the system). Is there any way to avoid this whithout spliting the 
select!? Unfortunatley i'm not able to upgrade to a newer 
DBI/DBD-Version because of serious compiling-problems...

Please be so kind and answer directly to to my mail-account.

Thx a lot,
Jan




Reply via email to