Re: pl/sql - help!!

Goldrich wrote:
>
> How do I issue a create table stmt w/in a PL/SQL block in a stored proc
> implementation. The syntax for my create table is fine-- it goes
> smoothly when entered at SQLPLUS command line. Same command w/in stored
> proc produces a syntax error.

  You can use DBMS_SQL package (ie dynamic SQL) as it supports DDL statement.   

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841