Subject Re: Fb 2.1 and TYPE OF in PSQL
Author juarez_r
--- In Firebird-Architect@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
> Firebird 2.1 has a new TYPE OF functionality that will allow to use the
> datatype of a domain in Stored Procedure parameters and declared
> variables in Procedures & Triggers. These "dependencies" will be tracked
> as well. After modifying a datatype of a domain, a recompile of the
> procedure would then recreate the procedure with the new datatypes.

Hi,

Why not use the the table column type?
Oracle has this feature:

Columname table.column%type;

Since your procedure will depends in some table, there is no need to
raise the dependency level to domains.
Also changing a column datatype will recompile your procedure as well.
And domain changes are harder than column changes...