如下过程在sql *plus里如何调用执行啊?谢谢!
CREATE OR REPLACE PROCEDURE xiaoqlj
(
GUID IN VARCHAR2,
OUTTIME IN VARCHAR2,
ReturnNum OUT NUMBER
)
AS
counter number;
BEGIN
select count(*) into counter from police.t_CH_pre
where id = guid;
if counter <> 0 then
UPDATE POLICE.T_CH_PRE
SET OUT_TIME = OUTTIME
WHERE ID = GUID;
INSERT INTO POLICE.T_CH_REC
SELECT * FROM POLICE.T_CH_PRE
WHERE ID = GUID;
COMMIT;
DELETE FROM POLICE.T_CH_PRE
WHERE ID = GUID;
COMMIT;
ReturnNum:=1;
ELSE
ReturnNum:=0;
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
ReturnNum:=0;
END;
上面这个过程在sql *plus里如何调用执行,大家帮忙。