""Ann W. Harrison"" ...
...

> Currently stored procedures declare variables in a sort of procedure
> preamble. They could declare the names of temporary data sets and the
> names and datatypes of their fields in the same fashion. During
> procedure compilation - from PSQL to blr - those declarations would be
> used to resolve references to temporary data sets - those defined
> within the procedure and those created outside the procedure.
>
> Not terribly elegant, but sufficient, I think.

Is this the same thing which i proposed when spoke about DLTT's ?

CREATE PROCEDURE SP (...) RETURNS (...)
AS
DECLARE LOCAL TEMPORARY TABLE T1 (
ID INT NOT NULL PRIMARY KEY,
VAL VARCHAR(255));
BEGIN
...
END

We can use any other keywords instead of
LOCAL TEMPORARY TABLE

Regards,
Vlad