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

Home -> Community -> Usenet -> c.d.o.server -> Re: DDL Statements in PL/SQL !?!

Re: DDL Statements in PL/SQL !?!

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 04 May 1999 03:11:47 GMT
Message-ID: <373356ea.2061692@netnews.worldnet.att.net> 





On Mon, 03 May 1999 03:51:43 GMT,


peter_veenstra_at_my-dejanews.com wrote:



>Why can't I execute DDL in PL/SQL and is there a better way to do this


>programmatically with out a lot of script writing? I want to pass a PL/SQL


>block a user name and have it do all the rest.





You can execute DDL in PL/SQL, but you need to use the
DBMS_SQL package. As I recall, it's documented in the
Application Developer's Guide.



Jonathan

Received on Mon May 03 1999 - 22:11:47 CDT












Original text of this message













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