From Tom Kyte, .and you can tell the original poster that dbms_sql has a parse interface that takes an array and the array can exceed 32k easily. http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:900628511 026#21444972511023 Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis <http://www.hotsos.com/courses/PD101.php> 101: 1/4 Calgary - SQL Optimization <http://www.hotsos.com/courses/OP101.php> 101: 11/8 Dallas, 12/13 Atlanta - Hotsos <http://www.hotsos.com/events/SYM05.php?event_id=36> Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -- //www.freelists.org/webpage/oracle-l