Myles Wakeham wrote:

>Can a stored procedure refer to domains as variable types? I can't seem to
>get this to work, and I'm wondering if this is an intentional limitation.
>
>For example, I've created a domain called ID (Integer). When I create a
>stored procedure, it won't accept the procedure as:
>
>CREATE PROCEDURE COMPANY_CHECK_STATUS_PRC (C_ID ID)
>
>It keeps complaining about ID as a domain reference. Can this be done?
>
>Myles
>
>===========================
>Myles Wakeham
>Director of Engineering
>Tech Solutions Inc.
>Scottsdale, Arizona USA
>Phone (480) 451-7440
>Web: www.techsol.org
>
>

Myles,

No, you can't (yet) use domains as SP parameters, you should use the
basic datatype, in your case integer.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br