Re: About dynamic SQL

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 11 Mar 2003 15:11:00 -0800
Message-ID: <3E6E6D04.C987E079@exesolutions.com>

Jerry wrote:

> 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.

Can't answer Q1 but the answer to Q2 is no.

There are still a few things DBMS_SQL can do that NDS can not do. One of which is execute a statement bigger than 32K.

Check out the differences at http://tahiti.oracle.com

Daniel Morgan Received on Tue Mar 11 2003 - 17:11:00 CST