给你个例子,成功返回T,失败返回F
CREATE OR REPLACE PROCEDURE "INSERTAREAS" (
tareaid IN VARCHAR2,
tareaname IN VARCHAR2,
tre IN VARCHAR2,
execresult OUT VARCHAR2
)
AS
BEGIN
INSERT INTO areas(areaid, areaname, re)
VALUES (to_number(tareaid), tareaname, tre);
execresult := 'T';
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
execresult := 'F' || SQLCODE;
END "INSERTAREAS";
/
CREATE OR REPLACE PROCEDURE "INSERTAREAS" (
tareaid IN VARCHAR2,
tareaname IN VARCHAR2,
tre IN VARCHAR2,
execresult OUT VARCHAR2
)
AS
BEGIN
INSERT INTO areas(areaid, areaname, re)
VALUES (to_number(tareaid), tareaname, tre);
execresult := 'T';
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
execresult := 'F' || SQLCODE;
END "INSERTAREAS";
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货