$activate_stream =$dbh4->prepare("INSERT INTO stream (source_code, stream_code, client_id, name, url, status_code, stream_data, feed_db, feed_table, last_update, report_db, sla, exclude_request, owned, push) VALUES(?, ?, 10, ?, ?, DISABLED, ?, production_feed002, ?, ?, ?, ?, ?, ?, ?)"); while (my @activate_results = $activate_info >fetchrow_array() ) { $activate_stream->execute(@activate_results) or die $activate_stream->errstr; } } $activate_stream->finish();