| Subject | Stored Procedure Question | 
|---|---|
| Author | Myles Wakeham | 
| Post date | 2004-05-29T22:52:21Z | 
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
            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