Re: LongReadLen: unable to allocate memory for define buffer
- From: jim@xxxxxxx (Jim Ursetto)
- Date: Tue, 17 Apr 2007 18:43:29 -0500
Thanks for the reply. It may be the case that this is an Oracle
issue, but after significant research I can find no other reports
of this particular issue nor any solutions. The official definition
of the error is "Exceeded the maximum buffer size for current
platform" which is unhelpful. The official solution is "upgrade to
Oracle 8 or later", which is exactly the opposite of my experience.
Unfortunately I'm not a DBA so there is a degree of opacity here.
If anyone knows of memory allocation and buffering tweaks for Oracle
that will solve this problem, please let me know.
At 06:20pm on 2007 April 17, Steven Lembark did write:
[I wrote]
| Perl | DBI | DBD::Oracle | Oracle | Status |
|-------+------+-------------+--------+--------|
| 5.5.3 | 1.12 | 1.02 | 7 | OK |
| 5.5.3 | 1.30 | 1.14 | 8.1.7 | FAIL |
| 5.6.1 | 1.48 | 1.16 | 9.2.0 | FAIL |
| 5.8.8 | 1.53 | 1.19 | 10.2.0 | FAIL |
Why is there a 32MB limit on LongReadLen on this platform?
Looks like an oracle issue: the one that worked
was O7; the ones that fail are 8+. There are
various oracle tweaks for memory allocation and
buffering, you might be hitting one of them.
I'd start on that end and work back towards DBI
since Perl's allocation of memory is pretty much
only limited by the O/S.
--
jim@xxxxxxx / 0x43340710 / 517B C658 D2CB 260D 3E1F 5ED1 6DB3 FBB9 4334 0710
.
- References:
- LongReadLen: unable to allocate memory for define buffer
- From: Jim Ursetto
- LongReadLen: unable to allocate memory for define buffer
- Prev by Date: LongReadLen: unable to allocate memory for define buffer
- Next by Date: Re: LongReadLen: unable to allocate memory for define buffer
- Previous by thread: LongReadLen: unable to allocate memory for define buffer
- Next by thread: Re: LongReadLen: unable to allocate memory for define buffer
- Index(es):
Relevant Pages
|
|
