oracle增加工资检查约束,检查约束调用函数Oracle SQL开发人员

在Oracle SQL开发人员中可以做这样的事情吗

CREATE FUNCTION fnCheckValid(accountidd IN NUMBER)

RETURN NUMBER

IS retval NUMBER(4,0);

BEGIN

SELECT COUNT(accountid_fk)

INTO retval

FROM tbl_AccountAuthentications

WHERE accountid_fk = accountidd;

RETURN(retval);

END;

/

ALTER TABLE tbl_AccountAuthentications

ADD CONSTRAINT chkCheckvalid CHECK(fnCheckValid(accountid_fk) <= 1);

我不断得到的错误是

Error starting at line 999 in command:

ALTER TABLE tbl_AccountAuthentications

ADD CONSTRAINT chkCheckvalid CHECK(fnCheckValid(accountid_fk) <= 1)

Error report:

SQL Error: ORA-00904: "FNCHECKVALID": invalid identifier

00904. 00000 - "%s: invalid identifier"

*Cause:

*Action:

该函数正在创建中，我可以找到它，但是当我尝试调用它时，我不断收到该错误

这就是我想要实现的

AccountID RegularID OpenID

1 5 null

1 null 10

1 null 11

1 6

因此用户不能创建2个普通帐户，但可以拥有任意数量的OpenID帐户

该表设置如下

CREATE TABLE tbl_AccountAuthentications(

newAuthID NUMBER(4,0)

CONSTRAINT naid_pk PRIMARY KEY,

accountid_fk NUMBER(4,0)

CONSTRAINT accid_fk

REFERENCES tbl_UserAccounts(account_id),

regularid_fk NUMBER(4,0)

CONSTRAINT rgid_fk

REFERENCES tbl_StrongRoom(password_id),

openid_fk NUMBER(4,0)

CONSTRAINT opid_fk

REFERENCES tbl_OpenID(openid)

);