note
derby
<p>
Gotcha. Well ... instead of a <code>$dbh->do(...)</code> ... which would read all the rows into memory before returning, I'd try
the prepare/execute/fetchrow approach and hope the underlying DBD/OCI does the right thing memory wise.</p>
<p>
<code>
my $sth = $dbh->prepare( $ctas_sql );
$sth->execute();
while( my $row = $sth->fetchrow_arrayref ) {
# do whatever with $row
}
</code>
</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-8930">
-derby
</div></div>
<p>
<b>Update:</b> Doh! just reread this and saw it was a create statement, not a select. In that case I'm guessing you're timing out somewhere. You may want to look into using DBI->trace to try and track that down.</p>
1159634
1159719