About dynamic SQL

Hi there,

I have two little questions:

1. Does Pro*C 1.6 support dynamic SQL? I remember many years ago I used OCI to achieve a report which accepts query criteria at running time in Oracle 6 environment. Is it the only choice at that time?
2. Can NDS in PL/SQL replace dbms_sql since 8i under all circumstances? If not, will you go for dynamic SQL in Pro*C or dbms_sql in PL/SQL?

Thanks. Received on Tue Mar 11 2003 - 16:16:30 CST