Re: Temporary Table Allocation

why don't you user pl/sql arrays, its much faster. Regards

Peter Secor wrote in message <696b4t$4of$1_at_news.nyu.edu>...
>Hello All,
>
> Does anyone have a good reference regarding temporary table allocation
> during a stored procedure call? I am looking to store the results of a
> subquery in a temporary table that I wish to exist only for the life
> of the surrounding query. So far I have declared tables before the
> subquery, but these do not seem to be of the correct format (I recieve
> type mismatch errors though the types I am using seem to be the same).
>
>Thanks,
>
> Peter
Received on Sun Jan 11 1998 - 00:00:00 CET