Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle7 procedure question(DDL in a procedure how?)

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

From: Kenny Gump <kgump_at_mylanlabs.com.nospam>
Date: Thu, 1 Jul 1999 10:18:42 -0400
Message-ID: <377b78ec.0@news.mountain.net>


You have to use DBMS_SQL package to use DDL.

Kenny Gump

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 Thu Jul 01 1999 - 09:18:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US