Re: DBMS_SQL & Forms 4.5 ?
Date: 1996/09/10
Message-ID: <9a7cc$122c1d.267_at_NEWS>#1/1
Try using a pcakage or stored procedure and pass the string you want to execute as a parameter. Or better yet, forms_ddl is great and is built into forms 4.5. If you need to call it from graphics or reports though a database package called by a pll is the best way. Keeps the call consistent between the 3 products.
Lewis
Friedel Hosenfeld <friedel_at_pz-oekosys.uni-kiel.d400.de> wrote:
>maybe there is an easy answer to my question:
>I tried to make a procedure in Forms (4.5.6.0.7, RDBMS: 7.1.4.3.2)
>with some calls of DBMS_SQL. But the Forms Designer tells
>me that it doesn't know "DBMS_SQL".
>With SQL*Plus the same procedure compiles fine!
>Bye,
> friedel
>--
> Friedel Hosenfeld http://www.pz-oekosys.uni-kiel.de/~friedel
>Ecosystem Research Centre friedel_at_pz-oekosys.uni-kiel.d400.de
> Schauenburgerstr. 112
> D-24118 Kiel * FRG private:
>http://www.toppoint.de/~friedel
> Ceterum censeo: die taz braucht mehr Abos!!! (www.taz.de)
Received on Tue Sep 10 1996 - 00:00:00 CEST