Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Catch*22?

PL/SQL Catch*22?

From: Jerry Apfelbaum <japfelba_at_ican.ca>
Date: 1997/11/06
Message-ID: <34626643.65C2CBEB@ican.ca>#1/1

Can anyone solve this conundrum?

In a PL/SQL script, I want to create a temporary table, do some SQL operations on that table, then drop the table.

Unfortunately, when Oracle goes to compile the PL/SQL, the table doesn't exist yet so I get a compile-time error and cannot run the script. Creating the table ahead of time defeats the purpose here; ie, I don't really want an unnecessary table hanging around. Also, using dynamic SQL for the DML is a bit of a crude workaround as I think that would make the usual PL/SQL DML operations rather cumbersome or even unworkable.

Is this a Catch*22? Anyone got any ideas?

Thanks in advance.

-- 
=================================================
Jerry Apfelbaum           email: japfelba_at_ican.ca
Eastern Sun Group Inc.    phone:     416.240.9695 
Toronto, Canada
Received on Thu Nov 06 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US