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
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