Re: Help: DBMS equivalent to FORMS_DDL procedure

From: <gsalem_at_fr.oracle.com>
Date: 1995/09/01
Message-ID: <427dlk$hdt_at_inet-nntp-gw-1.us.oracle.com>#1/1


nambrose_at_lssec.bt.co.uk (Nicholas Ambrose) wrote:
>In article <4223qj$jkl_at_niven.ksc.nasa.gov>, Jerry Murr <Jerry.Murr-1_at_kmail.ksc.nasa.gov> writes:
>|> X-URL: news:comp.databases.oracle
>|> Content-Transfer-Encoding: 7bit
>|> Content-Type: text/plain; charset=us-ascii
>|>
>|> In Oracle Forms, there is a packaged procedure named "forms_ddl"
>|> that allows any SQL command to be executed from PL/SQL in a Forms
>|> application (normally, PL/SQL is limited to DML commands). I am
>|> trying to move some of my PL/SQL Program Units from forms into
>|> database procedures, but I need to be able to execute DDL commands
>|> (such as the "alter role" command). Is there a DBMS packaged
>|> procedure that is equivalent to the Forms "forms_ddl" procedure?
>|>
>Exactly what version of Forms is this present in ? i can't see
>it in Froms3. However, in Oracle 7.0.15, there appears to be
>a package called DBMS_DDL which may do what you need.
>Nick
Hi,
- there is no forms_ddl in forms 3.
- the package is called dbms_sql (and I think it debuted in 7.1) rgds Received on Fri Sep 01 1995 - 00:00:00 CEST

Original text of this message