On 6 Jun 2002 at 1:23, goonct wrote:

>What is your advise if I need to dynamically create and drop table
>during runtime ?

Change your need. ;)
If you need a place to put a pack of records temporarily, you can
create a table and a generator. Your SP muct get a value-identifier
from generator and put/get records into/from the table using this
identifier. Before exit the SP has to delete it's records from table.
You also can develop a pack of UDF which organize a "heap" in
memory and manage it.

SY, Dimitry Sibiryakov.