CREATE OR REPLACE PROCEDURE proc_test AS v_single_day NUMBER (10); BEGIN DBMS_OUTPUT.put_line ('test aaa'); SELECT VALUE INTO v_single_day FROM t_global_variable WHERE modul = 'report' AND VARIABLE = 'back_day'; DBMS_OUTPUT.put_line ('test bbbb'); EXCEPTION --定义出错控制 WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM);--输出错误信息 -- RETURN; END;
v_single_day NUMBER (10);
BEGIN
DBMS_OUTPUT.put_line ('test aaa'); SELECT VALUE
INTO v_single_day
FROM t_global_variable
WHERE modul = 'report' AND VARIABLE = 'back_day'; DBMS_OUTPUT.put_line ('test bbbb');
EXCEPTION --定义出错控制
WHEN OTHERS THEN
DBMS_OUTPUT.put_line (SQLERRM);--输出错误信息
-- RETURN;
END;