Subject | Re: Fb 2.1 and TYPE OF in PSQL |
---|---|
Author | juarez_r |
Post date | 2006-11-20T23:24:29Z |
--- In Firebird-Architect@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
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...
<m.tonies@...> wrote:
> Firebird 2.1 has a new TYPE OF functionality that will allow to use theHi,
> 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.
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...