Re: Help: DBMS equivalent to FORMS_DDL procedure

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 Received on Fri Sep 01 1995 - 00:00:00 CEST