Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Catch*22?
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, CanadaReceived on Thu Nov 06 1997 - 00:00:00 CST
![]() |
![]() |