M
microwave
Unregistered / Unconfirmed
GUEST, unregistred user!
请问在存储过程中参数可否使用域?为何我下面的代码不能通过,
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
/* Stored procedures */
CREATE PROCEDURE INSERT_CUSTOMER
(
IID INTEGER,
INAME DNAME,
IAREA DAREA,
IADDR DADDR,
ITEL DTEL
)
RETURNS
(
RID INTEGER
)
AS
BEGIN EXIT; END ^
SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;
其中 DNAME DAREA 等是已定义的域,
而改成下面这样后才可能通过,为什么?
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
/* Stored procedures */
CREATE PROCEDURE INSERT_CUSTOMER
(
IID INTEGER,
INAME CHAR(8),
IAREA CHAR(2),
IADDR CHAR(50),
ITEL CHAR(15)
)
RETURNS
(
RID INTEGER
)
AS
BEGIN EXIT; END ^
SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
/* Stored procedures */
CREATE PROCEDURE INSERT_CUSTOMER
(
IID INTEGER,
INAME DNAME,
IAREA DAREA,
IADDR DADDR,
ITEL DTEL
)
RETURNS
(
RID INTEGER
)
AS
BEGIN EXIT; END ^
SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;
其中 DNAME DAREA 等是已定义的域,
而改成下面这样后才可能通过,为什么?
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
/* Stored procedures */
CREATE PROCEDURE INSERT_CUSTOMER
(
IID INTEGER,
INAME CHAR(8),
IAREA CHAR(2),
IADDR CHAR(50),
ITEL CHAR(15)
)
RETURNS
(
RID INTEGER
)
AS
BEGIN EXIT; END ^
SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;