Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL
JoeZ53 wrote in message <19990225153920.13527.00000334_at_ng-ch1.aol.com>...
>Unfortunately, Forms 4.5 only allows you to use PL/SQL version 1.2.
Dynamic
>SQL is available with version 2.0. Therefore, you will have to use a
stored
>procedure to execute true dynamic code.
It's not true. Dynamic SQL is dbms_sql package and you can call it from
PL/SQL 1.2.
You must only remove reference to constants from specification (i.e.
substitute '2'
instead of dbms_sql.v7). Also look at Foms 4.5 procedure 'forms_ddl'.
However, I can't believe that temporary tables is best decision of your problem.
Leon Grinberg leon_at_grant.kharkov.ua Received on Fri Feb 26 1999 - 02:21:05 CST