If you're getting a 'unavailable resources encountered during drop command', I'd be willing to bet you have a cursor on the temp table that hasn't been dropped ... I'd look at all the cursors you might run on that temp table and make sure there is a drop after it. Then I'd go back to dropping the table each time.
Karen > Thanks Karen for the reply. I know these errors are a mystery so love > any ideas... > > well I too used to do a 'drop table...' but I got so many 'unavailable > resources encountered during drop command' then a 'duplicate table' error > that I went this route instead. The other kicker is these errors will happen > in random instances. It could be the first time ran or later or even once > in a great while, won't error all day. I'm bringing in the network guy to > check 'stuff' out but it is a head scratcher. >
