Re: "Create Table" in Stored Procedure

In article <47k0tj$6ot_at_sundog.tiac.net> uplink_at_uplinktech.com (Anita M. Wilcox) writes:
>
> I am having a problem writing a stored procedure. I am using the
> PL/SQL language and so far its going pretty well. However, I need to
> create and drop a temporary table. From all of the documentation I
> have found, I am not able to issue the "Create Table" or "Drop "
> command. Right now, I create the table, then create the stored
> procedure, and then drop the table.
> Is there any way to create and destroy tables within PL/SQL?

If you are running RDBMS version 7.1.X, you can use the package DBMS_SQL to issue DDL statements, such as create/drop tables/views/indexes, truncate tables, etc.

I don't know where you can find documentation, but the source itself ($ORACLE_HOME/rdbms/admin/dbmssql.sql) does contain decent comment on how to use each and every function/procedure within the package.

Good luck.

--

 Alvin W. Law ........................................... Oracle Corporation
 Senior Technical Consultant ................ 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294