laszlo_spamh..._at_freemail.hu wrote:
> andrewst_at_onetel.com wrote:
> > Mayeb you want a GLOBAL TEMPORARY table?
>
> Since creating the search tables takes a fair amount of time and the
> graph is fairly non-volatile, I don't want to have to re-generate the
> search tables every session.
>
> I actually (kind of) solved the problem by generating dummy search
> tables manually... this allowed my package to compile, and the
creator
> procedure then did what it was supposed to (find the table, drop it,
> and re-create it with all the necessary data). But while this _does_
> work (as long as nobody drops my tables), it's not exactly the most
> elegant solution.
So why do you need to drop and re-create the tables each time? Do you
generate a different set of columns each time?
Received on Tue May 24 2005 - 07:45:16 CDT
