Re: Stored procedures and dynamic SQL

Zang,

Please check up on the dbms_sql package. Using that you can do all DDL statements.

Vikram.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 


In article <4ge3aq$jb0_at_news.voicenet.com>, zang_at_omni.voicenet.com (Zang) writes:


>PL/SQL can only perform Data Manipulation not Data Definition.  


>Therefore CREATE, DROP, and TRUNCATE statements are not allowed.  Only 

>SELECT, FETCH, OPEN, etc. are allowd in PL/SQL.  This applies to both 

>dynamic SQL and stored procedures.

>