DBD::Oracle out of memory
- From: "Pavel" <pavel@xxxxxxxxxx>
- Date: 20 Feb 2007 03:31:57 -0800
I have some problem with dbd-oracle 1.19
Its work fine if I use CLOB as a bind- variable in a loop.
like this:
While($id < $maxid)
{
$dbh_ora= dbh_con();
$dbh_ora->{LongReadLen} = 1024*500;
while ( my ( $id
,$field1
,$field2
)= $sth_pg->fetchrow_array())
{
$sth_ora->bind_param(1, $field1 );
$sth_ora->bind_param(2, $field1 ,{ ora_field=>'FIELD1' , ora_type
=> ORA_CLOB });
$sth_ora->bind_param(3, $field2 ,{ ora_field=>'FIELD2' , ora_type
=> ORA_CLOB });
}
$dbh_ora->commit();
$dbh_ora->disconnect();
}
But the memory increased until I get out of memory.
Exists solution fort this problem
I use:
Oracle 10G2
Perl 5.8.8
Linux Kernel 2.4.21
.
- Prev by Date: Re: connect as sysdba
- Next by Date: Re: ANNOUNCE: DBI 1.54 RC6 - including cool new DBD::Gofer stateless proxy
- Previous by thread: connect as sysdba
- Next by thread: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
- Index(es):
Relevant Pages
|
|
