will this work with creating indexes as well?
Noah
Jonathan Lewis wrote in message
<930772554.15974.0.nnrp-06.9e984b29_at_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 - 15:57:13 CDT
