Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL

Re: Dynamic SQL

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Fri, 26 Feb 1999 10:21:05 +0200
Message-ID: <7b5lif$oah@grant.grant.UUCP>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US