Subject | Domains and Why they wont work for I/O params in stored procs. |
---|---|
Author | Alexei Isac |
Post date | 2005-03-01T23:01:04Z |
I am a new FB user and I am not able to use defined domains in the
IN/OUT params of stored procs.
Are there any plans to change this behaviour ? The way I thought about
the usage for Domains, is you define a type (and behaviour) once and
refer to it in other places(just like #define in C/C++). That way you
only need to change it in one place if the defenition changes.
Anyone have any idea on why it was done this way ?
-Alexei
ps: If there is way to pass defined domains to stored procs, I am not
aware of it. In that case can someone tell me how to pass them. I get
the following error when I execute the SQL
SET TERM ^ ;
CREATE PROCEDURE name (
USER_NAME TYPE_IDENTITY
)
RETURNS
( USER_ID TYPE_IDENTITY)
AS
BEGIN
USER_ID = 1;
END^
SET TERM ; ^
IN/OUT params of stored procs.
Are there any plans to change this behaviour ? The way I thought about
the usage for Domains, is you define a type (and behaviour) once and
refer to it in other places(just like #define in C/C++). That way you
only need to change it in one place if the defenition changes.
Anyone have any idea on why it was done this way ?
-Alexei
ps: If there is way to pass defined domains to stored procs, I am not
aware of it. In that case can someone tell me how to pass them. I get
the following error when I execute the SQL
SET TERM ^ ;
CREATE PROCEDURE name (
USER_NAME TYPE_IDENTITY
)
RETURNS
( USER_ID TYPE_IDENTITY)
AS
BEGIN
USER_ID = 1;
END^
SET TERM ; ^