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