Re: Problem with fetching LONGs and LONG RAWs (ORA-01062)

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 7 Sep 2007 14:54:15 -0800
Message-ID: <46e1c887@news.victoria.tc.ca>

Mark D Powell (Mark.Powell_at_eds.com) wrote:

: > DBD::Oracle::db prepare failed: ORA-01062: unable to allocate memory

: This is late but any chance the memory error is due to the requested
: amount of free memory being unavailable to allocate rather than a
: limit?

I wondered that myself, the message does say "unable to allocate" after all.

Also, I always set the long read length during the connect, I don't know if that makes a difference.

my $dbh = DBI->connect( $data_source , $user_name , $user_pswd ,

                     { PrintError => 1 ,
                       RaiseError => 0 ,
                       LongReadLen => 1_000_000 ,
                     }
                   );

END{ $dbh->disconnect if $dbh }

: Just being curious cause Perl is on my list of things I would like to
: take up.

Highly recommended by me, though perl doesn't seem to be nearly as active as it was say ten years ago (for example the moderated news group rarely has any posts anymore). Received on Fri Sep 07 2007 - 17:54:15 CDT