Native Dynamic SQL in Oracle8i

Since Oracle8i's native dynamic sql is in this form:

EXECUTE IMMEDIATE <sql-stmt>
USING <var-to-bind-1> [...,<var-to-bind-n>]

I've made even the 'USING' clause of the above statement dynamic because it isn't known till runtime.

Now that all my dynamic sql (whole EXECUTE IMMEDIATE <sql-stmt>... USING <>) is in a variable, how can I invoke it to execute?

Thanks. Received on Wed Aug 21 2002 - 19:31:24 CDT