Re: pl/sql - help!!
From: Lun Wing San (Oracle) <"Lun>
Date: 1997/01/30
Message-ID: <32F0C7E9.25B8_at_qrcsun.qrc.org>#1/1
Date: 1997/01/30
Message-ID: <32F0C7E9.25B8_at_qrcsun.qrc.org>#1/1
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)27885841Received on Thu Jan 30 1997 - 00:00:00 CET