例如,请大虾诊断CREATE OR REPLACE FUNCTION GETOUID (classid IN NUMBER) RETURN NUMBER IS ouid NUMBER(10,0); BEGIN set transacntion read write; update tt set bb = bb + 1 where aa = classid; select bb into ouid from tt where aa = classid; commit; RETURN(ouid); END;
创建函数时,oracle显示 警告: 创建的函数带有编译错误。
呵呵!上面说错了!该存储过程为 CREATE OR REPLACE procedure GETOUID (classid IN NUMBER, ouid out NUMBER) is BEGIN set transacntion read write; update tt set bb = bb + 1 where aa = classid; select bb into ouid from tt where aa = classid; commit; END;
(classid IN NUMBER)
RETURN NUMBER
IS ouid NUMBER(10,0);
BEGIN
set transacntion read write;
update tt set bb = bb + 1 where aa = classid;
select bb into ouid from tt where aa = classid;
commit;
RETURN(ouid);
END;
警告: 创建的函数带有编译错误。
CREATE OR REPLACE procedure GETOUID
(classid IN NUMBER,
ouid out NUMBER)
is
BEGIN
set transacntion read write;
update tt set bb = bb + 1 where aa = classid;
select bb into ouid from tt where aa = classid;
commit;
END;