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