Would using DBMS_SQL help any? That way you could parse the SQL once and then iteratively call DBMS_SQL.BIND_VARIABLE or DBMS_SQL.BIND_ARRAY to bind just what you need (and what you've managed in your array). I know it's not as quick as NDS and involves more code for parsing, opening, closing, etc., but you wouldn't have to worry about having 0..N OPEN...FOR...USING statements around. But you would have to be cognizant of data types for the DBMS_SQL bind routines.

Just a thought and I agree that NDS can be annoying because of this.

HTH,

Heath