Re: Dynamic SQL
From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: 1999/02/26
Message-ID: <7b5lif$oah_at_grant.grant.UUCP>#1/1
Date: 1999/02/26
Message-ID: <7b5lif$oah_at_grant.grant.UUCP>#1/1
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 - 00:00:00 CET