Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL Statements in PL/SQL !?!
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
![]() |
![]() |