Re: oracle7 procedure question(DDL in a procedure how?)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Jun 1999 20:50:31 +0100
Message-ID: <930772554.15974.0.nnrp-06.9e984b29@news.demon.co.uk>

The commonest way is to use package dbms_sql (see my web page for a couple of examples).

There is also a 'dbms_utility.exec_ddl_statement()' facility.

You will need execute privileges on these packages, which are owned by sys.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Noah Arliss wrote in message ...
>How can I embed DDL into a procedure.. I have written a function to test
>whether a table exists in a database that returns a boolean, after testing
>this boolean value in a procedure I would like to create an index on that
>table.. SQL+ however does not like seeing the CREATE call within the
>procedure.. does anyone know how to embed DDL into a procedure?
>
>
Received on Wed Jun 30 1999 - 14:50:31 CDT