Re: "Create Table" in Stored Procedure

From: Jonathan Wayne Ingram <jwingram_at_whale.st.usm.edu>
Date: 1995/11/06
Message-ID: <47la8d$obe_at_thorn.cc.usm.edu>#1/1


: > 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?
Yes, I supposed you can do this, but you might be causing fragmentation in your database. Why not have the temp table around and clean it out before and afteryou use it?

Jonathan Received on Mon Nov 06 1995 - 00:00:00 CET

Original text of this message