Re: Temporary Tables Aliasing in Stored Procedure
Andrew Gilfrin wrote:
> I think you're confusing the point of temporary
> tables, the data in them is temporary not the
> table itself.
Hee, thanks! You are right, I did assume that the structure, as well as the data, was temporary.
>
> It doesn't really make sense to create the table
> in the procedure, you should just create it as a
> permanent entity in the db and then reference it
> in the stored procedure.
Well, I needed one to do just this:
> I can see the point of having a temporary
> structure in a procedure such as Oracle's PL/SQL
> tables but currently this isn't supported.
>
But now that's clear too. Thanks, I've learned alot!